|
|
|
|
Can I use backups in Microsoft SQL Server's Query Analyzer? Back
No
Because since V4.0 use a new media format to hold the output data , this media format support data compression and encryption .
But if you are using the 3.x version , you can use backup in Query Analyzer.
For example , you can restore a database from a full backup by entering following SQL statement in Query Analyzer:
restore database 'pubs' from disk='e:\sqlbackup\[pubs]_[full]_[2001_01_31_09_24_37].bk'
if you want to restore a database from a full backup and a differential backup , the SQL statements are:
1) . restore database 'pubs' from disk='e:\sqlbackup\[pubs]_[full]_[2001_01_31_09_24_37].bk' with norecovery
2) . restore database 'pubs' from disk='e:\sqlbackup\[pubs]_[diff]_[2001_01_31_10_01_16].bk'
|
|
|
Home