restore master database - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

restore master database

Author

Topic

chen149
Starting Member

19 Posts

Posted - 2005-05-04 : 13:02:27

I am new here.
I try to restore master database to the different location from the backup. but it is failed. It seems I have to setup the exactly same path as the original database.

Any suggestion is welcome.

Thanks a lot

Jun

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-05-04 : 15:17:20

Restore the database to the path that it is expecting, then you can use this article to move it:
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071&Product=sql2k

Tara

chen149
Starting Member

19 Posts

Posted - 2005-05-04 : 15:38:55

Hi Tara,

Thank you very much.I saw your post and response a lot.
I am not talking about move master database. I try to restore it from the backup copy and using the different path. Even the drive letter is different. I didn't have .mdf and .ldf file to move.

Thanks,

Jun

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources