![]() ![]() RESTORE DATABASE is terminating abnormally. Msg 3013, Level 16, State 1, Server PC9391, Line 1 Processed 3 pages for database 'masterx', file 'mastlog' on file 1. Processed 376 pages for database 'masterx', file 'master' on file 1. Mastlog' TO 'C:\SQLDATA\master_log.mdf '" Master.bak' WITH RECOVERY, MOVE 'master' TO 'C:\SQLDATA\master_data.md f', MOVE ' I have the BAK file locally, and I do not wish to overwrite my existing Master database, so I have been attempting to restore it as MasterX.Ĭ:\Users\me>SQLCMD -E -SMyPC -Q "RESTORE DATABASE masterx FROM Disk='c:\ Normally this runs on our production server, but I need to restore this to my local machine, which runs a different/newer version of SQL, in case that matters. I am trying to restore a copy of our Master database. ![]()
0 Comments
Leave a Reply. |