Programmabilities Blog

You can backup the DB from the server and then restore it on your local machine with installed MS SQL Server 2000. Then you can change or delete any pruned info from the DB on your local machine. Then you can backup the modified DB again and send that backup file (*.bak file). You can send this file with Gmail. There is about 3Gb available space.

How to backup...
1. Open Enterprise Manager
2. Select source DB
3. Right click on the selected DB. Select All Tasks->Backup Database... from the popup menu.
4. Select File and filegroup and add destination file name in the Backup dialog.
5. Press OK

How to restore...
1. Open Enterprise Manager
2. Select Databases node
3. Right click on this node. Select All Tasks->Restore Database... from the popup menu.
4. Type database name in the Restore as database textbox
5. Select Restore From Device
6. Press Select Device
7. Add backup file name
8. Press OK
9. In the Options tab check file pathes where your database will be restored.
10. Press OK
11. Select File and filegroup and add destination file name in the Backup dialog.
12. Press OK

Labels: sql

- posted by programmabilities @ 14:07 0 comments links to this post