During our scheduled restore of a database to a test server there were some kind of network maintenance which caused the restoring server to loose network connection and contact with the .bak-files. This caused the restore to be hanging in a restore state which I couldn´t break even if I restarted the SQL service. I tried to run "restore database dbname with recovery" but that didn´t work either.
The solution was to drop the database ("drop database dbname") and then restore from a fresh copy with the regular script.
Prenumerera på:
Kommentarer till inlägget (Atom)
0 kommentarer:
Skicka en kommentar