Backup (Recover) SQL Server Database without SQL Services Running?

Sure: Restore database dbnamegoeshere from disk='path to backup file here.

You can just copy the database files to another machine with SQL services running, and then attach them (right click on Databases, select Attach...).

MSDN for attaching a database (MDB File) In SQL Server Management Studio Object Explorer, connect to an instance of the Microsoft SQL Server Database Engine, and then expand that instance. Right-click Databases and click Attach. In the Attach Databases dialog box, to specify the database to be attached, click Add; and in the Locate Database Files dialog box, select the disk drive where the database resides and expand the directory tree to find and select the .

Mdf file of the database; for example: C:\Program Files\Microsoft SQL Server\MSSQL10_50. MSSQLSERVER\MSSQL\DATA\AdventureWorks2008R2_Data. Mdf Important noteImportant Optionally, to specify a different name for the database to attach as, enter the name in the Attach as column of the Attach Databases dialog box.

Optionally, change the owner of the database by selecting a different entry in the Owner column. When you are ready to attach the database, click OK.

I had to do this last night after a DB corruption – hamlin11 Jun 5 at 5:00.

In SQL Server Management Studio Object Explorer, connect to an instance of the Microsoft SQL Server Database Engine, and then expand that instance. Right-click Databases and click Attach. In the Attach Databases dialog box, to specify the database to be attached, click Add; and in the Locate Database Files dialog box, select the disk drive where the database resides and expand the directory tree to find and select the .

Mdf file of the database; for example: C:\Program Files\Microsoft SQL Server\MSSQL10_50. Optionally, to specify a different name for the database to attach as, enter the name in the Attach as column of the Attach Databases dialog box. Optionally, change the owner of the database by selecting a different entry in the Owner column.

When you are ready to attach the database, click OK.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions