Hi
Is there a stored procedure for backup and restore in SQL Server 7?
If there is, can someone provide me with the parameters please.
Thanks.
Printable View
Hi
Is there a stored procedure for backup and restore in SQL Server 7?
If there is, can someone provide me with the parameters please.
Thanks.
This is what I use for sybase (I suppose it´s the same):
to dump:
dump tran [your database] with truncate_only
go
checkpoint
go
dump database siefore to 'your filename'
go
to load:
load database [your database] from 'your device'
go
online database [your database]
go