Software

Ask something
Discussion Locked

SQL 7 retriving data

0 helpful
3 replies

by philip lee

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

1, How can i save the database and retrive it as it is saved later ?
2, How can i save the database and move it to another machine and use that saved copy.?

3 replies

by mtnsqs

You can use SQL server to 'backup" your DB to a File or to tape etc.

To move to another machine , copy the backup across, create the same db name and schema sizes etc, and then do a restore.

This will work with most veriosn of SQL server - its jsut easier to do in Sql 6 or 7 as the administrative interface is greatly improved in these later verions.

This discussion is closed to new replies.