Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chetancool
Starting Member
34 Posts |
 Posted - 2004-11-27 : 01:16:06
|
| Hi Group..This is chetan..I got a unique problem.My production sql server machine got crashed. as i hve taken backup a day before crash, so i was thinking i was safe.I got new machine and i have installed Sql server 2k on that. I have restored my user database with mdf and ldf files. but how can i get my user's databases jobs and all schedules back in the msdb database. since a new msdb database is created when i have installed sql. and when i m trying to restore the back of msdb on this, it is not allwoing me to do so. same is happing for master db.help me ...cjain |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-27 : 02:29:37
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=42798Kristen |
 |
|
|
chetancool
Starting Member
34 Posts |
Posted - 2004-11-29 : 06:48:35
|
| Thanks for your reply....i was able to restore the MSDB database properly. but when i was doing for the Master Database (after coping the files to the appropriate folder), the services itself is not starting. when i click on the start button, after that it is automatically going to the stopped stage. Plz help on this.cjain |
|
|
|
MuadDBA
628 Posts |
Posted - 2004-11-29 : 11:02:34
|
| You'll need to check the error log files in the LOG folder wherever you have installed SQL Server. Open it in notepad and see what it says.Also, you should use the BACKUP command within SQL Server to back up your databases. Backing up the MDF and LDF files is not the recommended practice. |
|
|
|
|
|
|
Master tables restore..