fill.txt

一个网络营销软件

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