Could anyone guide me how to restore Master, msdb to different server from the backup files.
thanks in advance.Why would you want to?
I would imagine it'd be like any other database...|||Infact we are moving all our database server stuff to newly purchased hardware..
i can script all logins and regenerate it in the new server, but i wanted to know the process of restore or detach/attach options for master database to different server..
thanks for your reply.|||If you retain the server name, then using -m from command line with SQLSERVR would alow you to restore master. MSDB is even easier than that, just restore, after you stop SQLAgent.
Showing posts with label guide. Show all posts
Showing posts with label guide. Show all posts
Monday, March 12, 2012
Subscribe to:
Posts (Atom)