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 you please suggest me on this?
Apr 20 '11 at 05:10 AM
Yes! Install SQL server on a server, restore the master and msdb, then you can restore your databases and transaction logs.
Apr 20 '11 at 05:11 AM
Apr 20 '11 at 05:16 AM
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.
True, I didn't think of that. I thought everyone stored them in the DB to have a backup of it. :(
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.
what about dbmail configuration do i need to configure again?
it should be working when you restore msdb but one way to find out for sure: give it a try after you restored it.
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
asked: Apr 20 '11 at 05:10 AM
Seen: 670 times
Last Updated: Apr 20 '11 at 05:10 AM
How do I port a SqlServer application that uses IDENTITY columns to oracle?
MAX WORKER THREADS
What are the most important things for a developer to know when moving from SqlServer to Oracle?
Connect to named and default instance
What are the trip of the trade when porting an application form SqlServer to Oracle?
Isnumeric Error for BigInt Values
Languages, date formats, CONVERT() and CAST()
What is the basic difference between clustered and a non-clustered index?
SLOW RUNNING PACKAGES
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.Ask SQL Server Central is a community service provided by Red Gate.