SQL SERVER Buckup files/database - help!!

[Namo]

Hello
When i used access i could easly make a buckup file to my database (with *.mdb file).

And i could easly make a buckup table in any database.

I have no idea how to do it with Sql Server.

How to do it? any info will help

Thanks!!
Namo.

[Ianpbaker]

Are you using SQL 6.5 or SQL 7.0 ?

[Namo]

Sql Server 7
Thanks.

[Ianpbaker]

Ok Then

First of all, open up enterptise manager. Expand the server and go down to and expand managment, then right click on backup and click on create new backup device. type in the name you want to call it, then click OK. Then right click the device on the right hand pane and fill out the form. click ok and hey presto your back up is now done.

Ian

[Namo]

Thanks Lan
But how can i make a buckup (file) and transfer it to other computer with Sql Server...
You know what i mean>? in access i can copy *.mdb file and take it to any comp with access and copy all DB... how can i do it with sql server?

Please let me know.
Thanks alot!!
Namo.

[Ianpbaker]

is the other server on the same network ?

ian

[Namo]

Other server

[Ianpbaker]

What I mean is you have two computers running two different SQL server's and you want to copy a database from one computer to the next. Am I right in saying that? if so can the two computers talk to each other through a network ?

ian

[Namo]

Yes , two computers running two different SQL server's and i want to copy a database from one computer to the next.. they CANNOT connect via server..

[Namo]

Any idea how to do it? is it possible?

[Ianpbaker]

Hi Namo

sorry about the delay, I forgot all about this thread.

this is a bit of a dirty way of doing it but it does the job.

First of all make a blank access database (name it what ever you like). Next,open up enterprise manager and right click the database you wany to copy. Go to all tasks and click on export database. Follow the wizard and when it says "where do you want to copy to", select access, then select the blank database you have just created. Select all tables then finish. This will copy all you tables and data into the access database. Next, take that database other to your other machine and fire up enterprise manager and create a new blank database. Right click it, all tasks, import data. Follow the wizard and use the access database as the copy from.

Right, now you have the database with all the tables and the field's, but there isn't any primary key's, relationship's, stored procedures etc. etc. If you have some of these things follow the next step

Go back to your original machine, right click the database, all tasks, generate SQL scripts. Deselect Script all objects, and select all options apart from all Table's and anything you have not got on your database. run these script's on your other machine using the query analyser, and providing you have named the database the same, it will make all the above mentioned

Hope this helps

Ian

[Namo]

Thanks alot , nice ideas.
Thanks again
Namo.

[Paul Warren]

LOL - Ian, that was so subtle I don't think anyone noticed it ! Maybe you should change your signature permanently.