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

avatar image

Shyam prasad
132 13 13 17

(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

avatar image

Håkan Winther
16.6k 37 46 58

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.

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: 1147 times

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

Copyright 2017 Redgate Software. Privacy Policy