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 |
|
Allen
Starting Member
20 Posts |
 Posted - 2012-04-27 : 21:31:51
|
| I have installed the management console and SS 2008 on my PC. I want to backup my e-commerce site and install it into my local db. What's the best way to do this.When I download my backup file, what tool should I use to restore it into my local db? |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-04-29 : 10:30:56
|
| Use the SSMS . Download the backup file onto your PC. Connect to your SQL Server Instance and use the RESTORE command .Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
Allen
Starting Member
20 Posts |
Posted - 2012-04-29 : 11:41:03
|
| Hello Jack - This all I have done. I am now trying to open my new db that I have done the restore from. Do I do this by doing an attach? If so, I have tried and then get an access error.Using Windows 7 |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-04-30 : 01:47:21
|
| Allen, if the BACKUP was used to prepare the file , use a RESTORE to restore the database. To check intergrity before the RESTORE do a RESTORE VERIFYONLY FROM DISK = ‘E:\backuppath\mydb.bak’.This checks for 1)backup set is present and header fields of pages 2)Are volumes readable?You'd only ATTACH if the files had been prepared with DETACHWhat access error are you getting? is it a security message?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
New installation question