sql 2008 脚本带密码的数据库

先通过

RESTORE FILELISTONLY From disk =  'F:\db.bak'
with MEDIAPASSWORD = N'password'

查询备份文件里的old_db_data和old_db_log路径，然后执行

RESTORE DATABASE newdbname

FROM DISK = 'F:\db.bak'
WITH MOVE 'old_db_data' TO 'G:\Data\newdb.MDF',
MOVE 'old_db_log' TO 'G:\Data\newdb_Log.LDF',
STATS = 10,
MEDIAPASSWORD = N 'password',
REPLACE
GO

其中，红色的变量，