BACKUP RESTORE

HOW DO I BACKUP UP AND RESTORE A DATABASE THAT IS ON SQL
7.0 SERVER, THAT IS ONE SERVER TO ANOTHER SQL SERVER 2000
ON AN ENTIRELY DIFFERENT SERVER WITH OUT USING TAPES,
PIPES, ETCHi
SQL 2000 will recognise SQL7 backups and convert them on restoration. You
can backup to a UNC address necessary or just copy the backup files across
your network. You can also use sp_detach_db and sp_attach_db to detach the
files from the SQL 7 server and re-attach them to the SQL 2000 server (after
copying them!)
John
"LARA31" <LARA31@.HOTMAIL.COM> wrote in message
news:0eea01c36bee$456ee5b0$a601280a@.phx.gbl...
> HOW DO I BACKUP UP AND RESTORE A DATABASE THAT IS ON SQL
> 7.0 SERVER, THAT IS ONE SERVER TO ANOTHER SQL SERVER 2000
> ON AN ENTIRELY DIFFERENT SERVER WITH OUT USING TAPES,
> PIPES, ETC|||Create the backup to a file on the SQL 7.0 server, then
run the T-SQL RESTORE command from the SQL 2000 server,
referencing the backup file on the 7.0 server using UNC.
This assumes that the SQL Server service account on the
2000 server has permissions to access the file on the SQL
7.0 server.