备份数据库:
backup database ywhs to disk='d:\ywhs.bak' with init
把ywhs.bak复制到另一台机器上,
还原数据库:
restore database ywhs from disk='d:\ywhs.bak'
backup database ywhs to disk='d:\ywhs.bak' with init
把ywhs.bak复制到另一台机器上,
还原数据库:
restore database ywhs from disk='d:\ywhs.bak'
LogPath="c:\具体路径\文件名""RESTORE DATABASE " + DBName +
" FROM DISK = '\\计算机名\共享目录名\备份文件名' WITH "
+"MOVE '"+logicDataName+"' TO '"+DataPath+"',"
+"MOVE '"+logicLogName+"' TO '"+LogPath+"',REPLACE ";