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,

can i recover logins with resoring of master, do thery work properly
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?

asked Apr 20 '11 at 05:10 AM in Default

Shyam prasad
122 ● 9 ● 9 ● 11

(comments are locked)

1 answer:

Yes! Install SQL server on a server, restore the master and msdb, then you can restore your databases and transaction logs.

answered Apr 20 '11 at 05:11 AM

Håkan Winther
15k ● 29 ● 35 ● 46

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.

Apr 20 '11 at 05:16 AM DaniSQL

True, I didn't think of that. I thought everyone stored them in the DB to have a backup of it. :(

Apr 20 '11 at 05:18 AM Håkan Winther

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.

Apr 20 '11 at 05:30 AM DaniSQL

what about dbmail configuration do i need to configure again?

Apr 20 '11 at 05:34 AM Shyam prasad

it should be working when you restore msdb but one way to find out for sure: give it a try after you restored it.

Apr 20 '11 at 05:39 AM DaniSQL

(comments are locked)