USE [Credit]
GO

ALTER INDEX [member_ident] 
ON dbo.member REBUILD
WITH (ONLINE=ON);

/*
Msg 2725, Level 16, State 2, Line 1
An online operation cannot be performed for index 'member_ident' because the index contains column 'photograph' of data type text, ntext, image or FILESTREAM. For a non-clustered index, the column could be an include column of the index. For a clustered index, the column could be any column of the table. If DROP_EXISTING is used, the column could be part of a new or old index. The operation must be performed offline.
*/

ALTER TABLE [dbo].[member]
ALTER COLUMN [photograph] varbinary(max);
GO

-- Now?

ALTER INDEX [member_ident] 
ON dbo.member REBUILD
WITH (ONLINE=ON);


USE master;
GO

ALTER DATABASE [Credit]
SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
GO


USE [master]
RESTORE DATABASE [Credit] FROM  DISK = N'S:\Data\CreditBackup100.bak' 
WITH  FILE = 1,  MOVE N'CreditData' TO N'S:\DATA\CreditData.mdf',  
MOVE N'CreditLog' TO N'S:\DATA\CreditLog.ldf',  STATS = 5

GO

