Renuka__
Hall of Fame
Points: 3656
More actions
June 3, 2008 at 2:21 am
#823456
Yes. The MSDB and Model DB needs to be restored from the back ups.
[font="Verdana"]Renuka__[/font]
Sara_DBA-629440
Right there with Babe
Points: 721
June 3, 2008 at 2:31 am
#823464
Thanks very much...is it not required to restore tempdb database?
[font="Comic Sans MS"]Sara[/font]
A ship in the harbour is safe . . . but that's not what ships were made for. 😀
Kyle Neier ,
SSCrazy
Points: 2252
June 3, 2008 at 7:00 am
#823574
There is no need to restore the tempdb database as it is re-created every time the SQL Server instance starts.
http://msdn.microsoft.com/en-us/library/ms190768.aspx
Kyle
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply