RESTORE database cxtrade
FROM DISK = 'D:/db2008'
WITH MOVE 'cxtrade' TO 'D:/Program Files/Microsoft SQL Server/MSSQL/Data/cxtrade.mdf',
MOVE 'cxtrade_log' TO 'D:/Program Files/Microsoft SQL Server/MSSQL/Data/cxtrade.ldf'
go
sp_updatestats
go
EXEC sp_addlogin 'ftuser', '123456', 'cxtrade'
go
FROM DISK = 'D:/db2008'
WITH MOVE 'cxtrade' TO 'D:/Program Files/Microsoft SQL Server/MSSQL/Data/cxtrade.mdf',
MOVE 'cxtrade_log' TO 'D:/Program Files/Microsoft SQL Server/MSSQL/Data/cxtrade.ldf'
go
sp_updatestats
go
EXEC sp_addlogin 'ftuser', '123456', 'cxtrade'
go