数据库版本查看与异地备份

--查看 SQL Server 2000 版本号 select serverproperty('productversion') ,serverproperty('productlevel') ,serverproperty('edition') select * into test1 from PSAMCard where 1=2 --建立空表 insert into test1 selecte * from PSAMCard --test1必须存在 --SQL Server2005 异地备份//共享文件不用$ use master exec master..xp_cmdshell 'net use z: \\server01\d$ "密码" /user:server01\dongcheng' backup database 数据库名 to disk='z:\备份文件名' exec master..xp_cmdshell 'net use z: /delete' --例子： use master exec master..xp_cmdshell 'net use z: \\server05\d$ "Perfect0" /user:server06\mashang' backup database ETL1DataTemp_劳动仲裁 to disk='z:\test\ETL1DataTemp_劳动仲裁.bak' exec master..xp_cmdshell 'net use z: /delete' declare @sql varchar(100) set @sql = 'z:\test\ETL1DataTemp_劳动仲裁'+convert(varchar(50),getdate(),112)+replace(convert(varchar(50),getdate(),108),':','')+'.bak' exec master..xp_cmdshell 'net use z: \\server05\d$ "Perfect0" /user:server06\mashang' backup database ETL1DataTemp_劳动仲裁 to disk= @sql exec master..xp_cmdshell 'net use z: /delete'