How To Restore SQL Server Data From Hard Disk Backup 1

[Gwena]

Hi Guys,

I need to restore an old data from SQL server, but I don't have backup files. What I do have is the hard disk backup on backup Cassettes. Is there a way to extract the data from the hard disk?

 

[SQLBill]

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

 

[Gwena]

Thanks for the Info, SQLBill.