Restore a DB without restoring master

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 a DB without restoring master

Author

Topic

CanadaDBA

583 Posts

Posted - 2004-08-06 : 13:08:21

If I backup a database and restore it on another server without backing up and restoring master, msdb, or model DBs, what happens? What things do I loose? For example, do I loose my table's columns descriptions?

Canada DBA

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-08-06 : 13:10:37

The only thing you will lose is:

Jobs
DTS Packages
Server Logins
Diagrams

The descriptions are stored with the user database.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

CanadaDBA

583 Posts

Posted - 2004-08-06 : 14:16:21

Thank you Derrick for your prompt reply.

quote:
Originally posted by derrickleggett

The only thing you will lose is:

Jobs
DTS Packages
Server Logins
Diagrams

The descriptions are stored with the user database.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

Canada DBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources