如何异地建立SQL数据库

[leafcao]

我需要手动输入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

[leafcao]

应该是set @dbFilePath ='\\test\D:\Test1\Test1'

[davorsuker39]

???????