scripts to backup/restore

[sssdexter]

Hi,

Is it possible to use a script to back/export database in Query Analyzer instead of using enterprise manager? If do, how do the scripts looks like?

I know if Oracle, then we can use exp/imp command in DOS prompt or in *.bat file, wondering SQL Server can do the same thing?

Thanks a lot.

 

[JamesLean]

Yes you can. Look up the BACKUP and RESTORE statements in BOL.

--James

 

[sssdexter]

Hi,

Thanks