question

Shyam prasad avatar image
Shyam prasad asked

server crash?

One of our server creashed with disk fail(operating systerm files disk),we have backup files(full and tlog) how can i recover my server to the work properly, 1. can i recover logins with resoring of master, do thery work properly 2. Can i get the jobs,dts packages, ssis packages and mail configuration if i restore msdb db or do i need to do anything else Can you please suggest me on this?
sql-server
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Håkan Winther avatar image
Håkan Winther answered
Yes! Install SQL server on a server, restore the master and msdb, then you can restore your databases and transaction logs.
5 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DaniSQL avatar image DaniSQL commented ·
If his DTS and SSIS packages were running from file and it was stored in the failed disk he is out of luck. But if it were stored and run off of msdb database he should be okay when he restore msdb database. You will get your jobs restored when you restore msdb database.
1 Like 1 ·
Håkan Winther avatar image Håkan Winther commented ·
True, I didn't think of that. I thought everyone stored them in the DB to have a backup of it. :(
0 Likes 0 ·
DaniSQL avatar image DaniSQL commented ·
I still have half of the packages running from file at work but i do have a windows server backup available for DR(it takes a while to get it) but also i have a copy them in multiple disks too. However, I'm planning to put them in source control in the near future.
0 Likes 0 ·
Shyam prasad avatar image Shyam prasad commented ·
what about dbmail configuration do i need to configure again?
0 Likes 0 ·
DaniSQL avatar image DaniSQL commented ·
it should be working when you restore msdb but one way to find out for sure: give it a try after you restored it.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.