fill.txt

来自「一个网络营销软件」· 文本 代码 · 共 19 行

use master

if exists (select * from sysdevices where name='Market')

       EXEC sp_dropdevice 'Market'

Else

       EXEC sp_addumpdevice 'disk','Market', 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\Market.mdf'

 

restore database Market

from disk='c:\TempDB\Market'

with replace