I am having a problem trying to back-up and restore my DB using MS recommended script, link:
http://msdn.microsoft.com/en-us/library/ms162133(v=sql.100).aspx. Basically I just copied and pasted the code and just changed the DB name and where to delete the back up files. I
do have MS SQL server management studio installed, so to delete the files I've changed it to '
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\DB_NAME'.
When it is time to do the restore, it fails. Here is a snippet of the code:
Try
rs.SqlRestore(srv)
Catch ex As Exception
MsgBox("" & ex.Message)
End Try
As for an error message, all I get is 'Restore failed for server: My s ...
Go to the complete details ...