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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment