如何异地建立SQL数据库
我需要手动输入IP地址,然后根据这个输入内容在指定服务器上建立SQL数据库,
test是输入的IP地址
declare @dFile varchar(500)
declare @lFile varchar(500)
declare @dbname varchar(2)
declare @dbBackFilePath varchar(500)
declare @dbFilePath varchar(500)
set @dbBackFilePath = '\\test\D:\Test1'
set @dbFilePath ='\\特斯塔\D:\Test1\Test1'
set @dFile=@dbFilePath+'\1.mdf'
set @lFile=@dbFilePath+'\1_log.ldf'
set @dbname = '1'
RESTORE DATABASE @dbname
FROM DISK =@dbBackFilePath WITH FILE = 1,password = '',NOUNLOAD , STATS = 10, RECOVERY,
MOVE N'IETS_00001_Data' TO @dFile, MOVE N'IETS_00001_Log' TO @lFile