restore database when sql server won't start
Posted on 2011-10-15
I have a single instance of SQL server 2008 running on Server 2008 R2. The SQL program files and most of the datafiles are on the main server box; a few data files from a single partitioned table were on an external storage device that failed.
I have a complete backup of the database. But SQL server won't start, so I can't use SQL Server Management Studio to do the restore.
It seems that all I really need to do is to use the complete backup (1Terabyte) to get the 100 GB of datafiles restored to the external storage device.
Is this the most efficient way of getting restored? How do I do this?