how to restore database backup file to local end.

dear friend,

I created the backup file using discount's backup tool.

I download the backup file to my local computer. How can I restore the backup file to my local computer. because it contains so many new datas. I need to add more table to this database and then attached it to the server.

Thanks a lot.

 

Hi,
Unless I'm mistaken you'll need to sync with the remote database from a local copy of SQL Server or use the on-line web based SQL tool to create scripts.
If there is a way to work locally with a DASP backup I'm not aware of it but hopefully one of the DASP staff will make a comment soon. ;-)
All the best,
Mark

 

thanks

please let me know how to sync with the remote database from a local copy of SQL Server.

thanks a lot!

 

thanks! I will try it

 

Dmitri,

I have a question regarding the community post.

For the benefit of any other readers, here is the text:

"Backing up and restoring SQL Server databases is a broad and complex subject and there are numerous ways to do it. Please treat the below instructions as an example and refer to Books Online for the detailed explanation.

* Right-click the "Databases" folder and select "Restore Database..." option
* In the "Restore Database" dialog box, on "General" page, in the "To Database" text field either type a new database name (if you are restoring to a new database) or select the existing database from the drop-down menu.
* Under the "Source for restore" section select "From device" radio button
* In the "Specify Backup" dialog box select "File" from the "Backup Media" drop-down menu
* Click "Add" button, locate your backup file, and click "OK" and again "OK" buttons.
* In the "Select the backup sets to restore" select the check-box next to the backup set you just added
* Optionally, you can go to "Options" page and select the options you find appropriate
* Click "OK" button to initiate the restoration process"

[End of Community Post]

My question is: Where are you when you start this whole process? What program are you using?

Thank you for your trouble.

Eric alias Greek

 

Thanks

Dmitri,

Thank you for the prompt response.

Eric

 

Error Message

Dmitri,

When I click the Add button, I get this error message:

"Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

Additional information:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

The EXECUTE permission was denied on the object 'xp_fixdrives', database 'mssqlsystemresource', schema 'sys'. [Stated four times]

(Microsoft SQL Server, Error: 229)"

Do you have an explanation for this?

Thank you for your trouble.

Eric