RESTORE DATABASE 时用到的 with move 后面的 怎样知道是什么比如
"RESTORE DATABASE "+database+" FROM DISK ='"+ls_dir+"\back12.bak' WITH MOVE 'north_data' TO '"+ls_dir+"\"+database+".mdf', MOVE 'north_log' TO '"+ls_dir+"\"+database+".ldf'"里面的 'north_data' 'north_log' 怎样知道呢?
"RESTORE DATABASE "+database+" FROM DISK ='"+ls_dir+"\back12.bak' WITH MOVE 'north_data' TO '"+ls_dir+"\"+database+".mdf', MOVE 'north_log' TO '"+ls_dir+"\"+database+".ldf'"里面的 'north_data' 'north_log' 怎样知道呢?
你就能得到逻辑文件名.
RESTORE FILELISTONLY FROM DISK='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\test.bak'
create table t (LogicaName varchar(20),PhysicalName varchar(200))insert into t exec('restore filelistonly from disk=''[备份文件]'' ')
create table t (LogicalName varchar(20),PhysicalName varchar(200), ...[其他字段]...)insert into t exec('restore filelistonly from disk=''[备份文件]'' ')select @x=LogicalName from t where 条件