Home Forums SQL Server 2005 Administering Can we restore databases from database other than 'master' database? RE: Can we restore databases from database other than 'master' database?

  • This isn't a database level issue, it's a server permissions issue to create a db. The context doesn't, AFAIK, need to be master. I suppose you could restore these from msdb, or model, but you need a context on a new server.

    In a DR situation, you won't have the proc there, unless it's in a backup of master or msdb (or model if you restore that).

    what not have a script that does this, connect to the server (master or msdb) and then start the restores?