Thanks for the reply.

Why shouldn't I drop the clustered indexes? - they're not needed (hence why non exist), as they're only needed for the move.

Solved! Not quite sure why though.

The fact that I could restore the log manually, said something was up with the Agent starting automated task. It definitely wasn't a permissions issue....

Thanks for the suggestion.

Unfortunately, this will not work for my scenario. The database from what I know is around 275GB in size, not sure of the log file size.

I...

Thanks for the replies.

The question was more around if there was any other way to release the unused space back to the OS apart from DBCC SHRINKFILE, as there isn't,...

Thank you for the clarification.

Also, am I right in thinking I can only change for columns which have char, varchar, text, nchar, nvarchar, and ntext as their datatype?

I simply ran @@VERSION and from the build details I was able to cross-reference with http://support.microsoft.com/kb/321185 to confirm definitively which CU has been applied.

Perfect, thanks.

Bob, thank you, this is working as I'd hoped. I can sort of see what I needed to do.

One thing has just occurred to me though, I need a date...

Thank you.

Code to retrieve disk information needed via Powershell

Get-WMIObject Win32_LogicalDisk -filter "DriveType=3" -computer (Get-Content c:\computers.txt) | Select SystemName,DeviceID,VolumeName,@{Name="size(GB)"; Expression={"{0:N1}" -f($_.size/1gb)}},@{Name="freespace(GB)";Expression={"{0:N1}" -f($_.freespace/1gb)}}

Of the back of this, I've created a table on...

Right I've been able to connect to my instance of sql server via Powershell and run a simple select. I've also figured out the command to retrieve the information I...

I'm a Powershell newbie so will need to look into first creating the script to get the data I need, then connecting to SQL Server via Powershell to populate my...

Yeh, I want to stay away from enabling anything on the server.

It's proving to be a lot more complex than I first thought, for the sake of one missing metric...