Restore a DB without restoring master | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Restore a DB without restoring master

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? CanadaDBA
From the point of view of performance, you loose statistics, but runing Update Statistics after restore all is Ok.
If you have any schedule job associate with that database, you have to recreate in new server. Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
do I loose my table’s columns descriptions?
quote:Originally posted by LuisMartin

CanadaDBA
no but you will lose your logins… Cheers
Twan
Let me see if I follow you.
If with descriptions you mean columns table description, no. Because belong to user database.
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
Thanks guys. I also received the following from Derrick. The only thing you will lose is: Jobs
DTS Packages
Server Logins
Diagrams The descriptions are stored with the user database. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
CanadaDBA
]]>