Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How To Restore SQL Server Data From Hard Disk Backup 1
- Thread starter Gwena
- Start date
-
1
- #2
What do you mean by 'hard disk backup'? Do you mean something like an operating system backup?
If the backup you do have was made by just backing up the files on the hard disk, that won't work (one exception below). SQL Server databases (files) can not be backed up while they are in use unless you use the SQL Server backup commands (you can use 3rd party software as long as they use the SQL Server commands for the backups).
The one exception is if the database was offline (detached or services stopped). Then a backup of the files will work. In this case all you need to do is copy the files back to their original location and attach them to SQL Server (sp_attach_db).
-SQLBill
If the backup you do have was made by just backing up the files on the hard disk, that won't work (one exception below). SQL Server databases (files) can not be backed up while they are in use unless you use the SQL Server backup commands (you can use 3rd party software as long as they use the SQL Server commands for the backups).
The one exception is if the database was offline (detached or services stopped). Then a backup of the files will work. In this case all you need to do is copy the files back to their original location and attach them to SQL Server (sp_attach_db).
-SQLBill
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
