Stored Procedure for backup.

[PaulB]

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.

[jp_schwartz]

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