Monthly Archives: June 2014

TSQL to copy a most recent sql server backup to a new location

In this blog I would like to post the TSQL script that I have written and am using to move a most recent sql server backup from one location to another. I am using the script inside a sqlagent job that … Continue reading

Posted in SQL Server DBA Stuff | Tagged , , | Leave a comment

SQL 2012: System.Data.SqlClient.SqlError: Cannot use file ” for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it. (Microsoft.SqlServer.SmoExtended)

I presented a new lun to the sql server 2012 cluster and tried to restore a database to the new storage. I got the below error: “System.Data.SqlClient.SqlError: Cannot use file ” for clustered server. Only formatted files on which the … Continue reading

Posted in SQL Server DBA Stuff | Tagged , | 2 Comments