msde 的常见操作

备份数据库命令
osql -Usa -Pemsems -Q "RESTORE DATABASE db FROM DISK ='D:/db'"

恢复数据库命令
osql -Usa -Pemsems -Q "RESTORE DATABASE db FROM DISK ='D:/db' with move 'db' to 'D:/MSSQL/data/db_data_5.dat', move 'cmedb_log' to 'D:/MSSQL/data/db_log_5.dat'"

osql -Usa -Pemsems -Q "RESTORE DATABASE db FROM DISK ='D:/db' with move '数据设备文件' to '数据设备物理路径', move '日志设备文件' to '日志设备物理路径'"

 

修改SA密码

sp_password @old = null, @new = '新的密码', @loginame ='登陆名'