Backing up a SQL Server 2005 database on SQL Server 2000 EE

Tags:
Backup & restore
SQL Server 2000
SQL Server 2005
SQL Server backup
I have created a large database in SQL Server 2005 Developers Edition, and I intend to put my backup on SQL Server 2000 Enterprise Edition. Is there an easy way to go about this procedure?

Answer Wiki

Thanks. We'll let you know when a new response is added.

To backup your MS SQL Server 2000 database, please follow these steps:

1. Open Enterprise Manager.
2. Connect to your MS SQL Server 2000 database.
3. Right-click your database, expand All Tasks and select Backup Database.
4. Under Backup, select Database – complete.
5. Under Destination, click Add.
6. Enter the path and file name for the backup file.
7. Click OK.
8. Review the settings for the backup.
9. Click OK to begin the backup.

The instructions above will create a complete backup of your database. This is the recommended method to ensure that all data is backed up.

You will want to use the <a href=”http://itknowledgeexchange.techtarget.com/sql-server/back-to-basics-the-backup-database-command/”>BACKUP DATABASE</a> and <a href=”http://itknowledgeexchange.techtarget.com/sql-server/back-to-basics-the-restore-database-command/”>RESTORE DATABASE</a> commands to backup the database, and then restore it to the second machine.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following