Restoring Databases

I'm restoring user databases and I would like
confirmation that the system databases(master, model,
msdb)should be restored as well.
Any guidance would be appreciated.It Depends
What broke? Why are you restoring? What are you trying to accomplish?
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Me" <anonymous@.discussions.microsoft.com> wrote in message
news:0c4501c3fb27$9f373e80$a401280a@.phx.gbl...
> I'm restoring user databases and I would like
> confirmation that the system databases(master, model,
> msdb)should be restored as well.
> Any guidance would be appreciated.|||Hi,
What are you trying to accomplish by restoring system databases.
1. User Databases can be restored directly
2. MSDB, Model also can be restored directly
For restoring Master database we should start SQL server in Single user
mode.
Thanks
Hari
MCDBA
"Me" <anonymous@.discussions.microsoft.com> wrote in message
news:0c4501c3fb27$9f373e80$a401280a@.phx.gbl...
> I'm restoring user databases and I would like
> confirmation that the system databases(master, model,
> msdb)should be restored as well.
> Any guidance would be appreciated.