Moving database

[thambipi]

Our vendor has created a MS SQL Server database in their office.

They have to transfer the database to use, so that we can use it with our web application.

How can we do that.

Can they ZIP the database file and send it to.

When we receive it how can access the data

Please help

 

[polash]

You can backup Option to make a Back up that Database. you will find it at All Task of that data base. When you want to use it in your office you make the proper name of that backup file. Then you take to your office and use the Restore option of that Backup file.

 

[Cagliostro]

They can detach database and zip it. After, you can unzip and attach it. John Fill

 

[Guest_imported]

The version I have is MS SQL server 2000.

Our Clien has onlu MS SQL server 7 version.

When we backuped in 2000 they could read it in 7.

What can do.

When we backup can we specify the version it is going to get
restored.

Jegen