Friday, March 30, 2012

Restored All Database Except for Master

Hi there,
Yesterday we built a new SQL server 2000 SP3, we restored all company
database using our b-up software. We tested them and our apps seems to work
fine against the newly built SQL server.
Question that is burning my head is: we restored everything except the
MASTER, MODEL, MSDB and PUBS. It was a matter of not knowing if they MUST be
restored together with our own databases.
Mind you, all our apps can talk and write and no problem at all. Do we still
need to restore these ones to our new SQL server?
Any advises or suggestions is much appreciated. Any questions is appreciated
too.
TIA
DMCYou might want to browse thru these to see why you may or may not want to
move the system dbs and what is involved. By the way there is nothing
special about Pubs, it is a sample db and is usually removed from production
servers.
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"dmc" <dario@.semiconductor.com> wrote in message
news:ebjbO6z9EHA.2984@.TK2MSFTNGP09.phx.gbl...
> Hi there,
> Yesterday we built a new SQL server 2000 SP3, we restored all company
> database using our b-up software. We tested them and our apps seems to
> work
> fine against the newly built SQL server.
> Question that is burning my head is: we restored everything except the
> MASTER, MODEL, MSDB and PUBS. It was a matter of not knowing if they MUST
> be
> restored together with our own databases.
> Mind you, all our apps can talk and write and no problem at all. Do we
> still
> need to restore these ones to our new SQL server?
> Any advises or suggestions is much appreciated. Any questions is
> appreciated
> too.
> TIA
> DMC
>sql

No comments:

Post a Comment