[dba-SQLServer] Restore

John,

Yes, I create new databases all the time from backups.  Select the restore
task and then change the database name to your new database name.  On the
General tab, there is a restore set of option buttons with the options
Database, Filegroups or Files, or From Device.  Select From Device and use
the dialogs to locate your backup file.  Once you have selected a backup
file, under the Options tab, you should see the paths for the mdf and ldf
files.  Change as needed.  Then restore.  

Good luck

Ken

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John W.
Colby
Sent: Sunday, September 26, 2004 9:25 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Restore

Will a SQL Server restore build the db containers or do they have to be
present already?  IOW if I lost everything, is a backup enough to get the db
working on a different machine?

John W. Colby
www.ColbyConsulting.com 


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com