Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-04-25 : 08:13:03
|
| jimbo writes "I work for a company that has a operations technology solution based on MSSQL. I wanted to start experimenting with Reporting Services to make custom reports from this database. I contacted the hosting company, and requested they setup a ftp transfer of the database to me so I would not be working with "live" data. They have done this. Every night, I receive via ftp two files. They are:im_cs"companyname"OP001, and im_cs"companyname"OP001backup. Neither of these files has and extension on the filename. I asked the hosting company about this, and they told me that these are "backup" files, and would have to be restored.My question is: How do I "create" a new database using these backup files, since one does not exist on my server. When I try to do a restore, Enterprise Manager looks for specific backup files tied to a specific database. Thank you in advance for any help you can give me." |
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2005-04-25 : 09:45:10
|
| Try doing a:1. Restore Filelistonly from disk = 'Location of your backup files'or2. Restore Headeronly from disk ='Location of your backup files' If they are valid backups then you can do:Restore Database 'Your DBName' from disk = 'Location of your backup fiels' with MOVE 'DataFilename(s) from number 1 above' to 'path for new datafilename',MOVE 'LogFileName(s) from number 1 above' to 'path for new logfilename', Replace, RecoveryHTH,JamesH. |
 |
|
|
|
|
|
restore sql database