Showing posts with label ent. Show all posts
Showing posts with label ent. Show all posts

Tuesday, February 21, 2012

Restoring database question plz help!.

yesterday my sql server 2000 ent crash because of an operating system problem i seem to have lost all my .ndf, .ldf, .mdf files from the DATA folder but i still have my full backup files in the BACKUP default folder from the day earlyer can i still restore my database to the state prior with all my data in it.You can restore the database back to the time of the completion of the last backup. If you do only complete database backups, you can restore to the end of the last backup. If you do incremental backups, you can restore the last complete backup plus all of the incrementals in an unbroken chain. If you have any missing incrementals, the ability to restore them stops with the first one you are missing.

-PatP|||so your saying that i can recover lets say all my databases under that server as long as i have the full back up file for those databse i dont need the datafiles ?|||basically the .BAK file as all the information. what does the master database containt ?|||have a look at this topic on Books online..
"Restoring the master Database from a Current Backup"
Once you are done with Master you can restore user dbs with old .BAK files.|||The master database contains "system" things like logins/passwords, linked servers, etc.

The msdb database contains things like SQL Agent jobs, DTS packages, etc.

These things are important, but are rarely "life or death" issues.

-PatP

Restoring database question plz help!

Here is the question if i reinstall sql server 2000 ent can i use my full back up file to reproduce all of my prior existing database and do i need the data file like the .ldf, .mdf, .ndf to do this and if so i do i do this without the data filesYour backup file should be all you need to restore your database to the moment that it was backed up. You will need to restore log files to recover any changes since the backup was made.
You should test your backup/restore plan first to make sure it works and you know how to do it before you wipe out your current installation!|||OK thanx but i cant test this because my sql server service doesnt want to start and i have admin rights. it givin me a unexpected error is the best thing here to reinstall sql server and then restore the back up file.|||basically rebuild the ole thing again.