January 7, 2010 at 9:52 am
Hi..
restore database master from disk = 'M:\sudhakar\backup\master070110.bak' with move 'master' to 'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf' ,
move 'mastlog' to 'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.ldf' , replace
I am trying to restore the master database in the sql server 2005 standard edition , systems giving the error message.
Msg 3179, Level 16, State 1, Line 1
The system database cannot be moved by RESTORE.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Pls help to resolve this issue. thanks in advance.
January 7, 2010 at 9:59 am
why are you trying to move its files, that should be done via the startup parameters.
restore the master database with the replace option so it restores the files to their current location. Then use this procedure to move its files:
http://msdn.microsoft.com/en-us/library/ms345408(SQL.90).aspx
you MUST move mssqlsystemresource to the same location at the same time.
---------------------------------------------------------------------
January 7, 2010 at 10:01 am
Note sure if this is the same link but may also help you:
http://msdn.microsoft.com/en-us/library/ms345408.aspx
Gethyn Elliswww.gethynellis.com
January 7, 2010 at 10:15 am
Thanks for your reply....
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply