备份:Backup Database Appdata to AppdataBkp Backup Database appdata to Disk='c:\backupData\appdatabkp.bak'恢复:Restore Database Appdata from appdatabkp
执行:Backup Database Appdata to AppdataBkp Backup Database appdata to Disk='c:\backupData\appdatabkp.bak'Restore Database Appdata from appdatabkp
备份到文件: backup database <MyDatabaseName> to disk=<MyBackFile> with replace 从文件恢复: retore database <MyDatabaseName> from disk=<MyBackFile> with format
如果是SQL Server Use Master 备份:Backup Database Appdb to AppdbBak Backup Database Appdb to Disk='c:\bakData\AppdbBak.bak'恢复:Restore Database Appdb from AppdbBak
备份:Backup Database Appdata to AppdataBkp Backup Database appdata to Disk='c:\backupData\appdatabkp.bak'恢复:Restore Database Appdata from appdatabkp
对于桌面型如Access,可以把数据库文件打包另存为就是备份,拷贝覆盖就是恢复。
Backup Database appdata to Disk='c:\backupData\appdatabkp.bak'恢复:Restore Database Appdata from appdatabkp
Backup Database appdata to Disk='c:\backupData\appdatabkp.bak'Restore Database Appdata from appdatabkp
backup database <MyDatabaseName> to disk=<MyBackFile> with replace
从文件恢复:
retore database <MyDatabaseName> from disk=<MyBackFile> with format
Use Master
备份:Backup Database Appdb to AppdbBak
Backup Database Appdb to Disk='c:\bakData\AppdbBak.bak'恢复:Restore Database Appdb from AppdbBak
Backup Database appdata to Disk='c:\backupData\appdatabkp.bak'恢复:Restore Database Appdata from appdatabkp