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?
more ▼

asked Apr 20, 2011 at 05:10 AM in Default

Shyam prasad gravatar image

Shyam prasad
132 13 13 15

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
Yes! Install SQL server on a server, restore the master and msdb, then you can restore your databases and transaction logs.
more ▼

answered Apr 20, 2011 at 05:11 AM

Håkan Winther gravatar image

Håkan Winther
15.6k 35 37 48

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, 2011 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, 2011 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, 2011 at 05:30 AM DaniSQL
what about dbmail configuration do i need to configure again?
Apr 20, 2011 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, 2011 at 05:39 AM DaniSQL
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 20, 2011 at 05:10 AM

Seen: 1018 times

Last Updated: Apr 20, 2011 at 05:10 AM