IF EXISTS (SELECT NAME FROM SYSDATABASES WHERE NAME = 'eas50new')
DROP
DATABASE eas50new
GO
--RESTORE FILELISTONLY from
disk='e:\eas50back\eas50'
restore database eas50new from
disk='e:\eas50back\eas50'
with move 'eas50new_data' to
'e:\data\eas50.mdf',
move 'eas50new_log'to 'e:\data\eas50.ldf'
go
阅读(2031) | 评论(0) | 转发(0) |