Transact-sql Backup to another server

Discussion in 'Databases' started by kayo, Nov 21, 2009.

  1. #1
    Hi,

    I have connected 2 servers in Management Studio and using script to backup from one server to another server.
    First using query on server1:
    BACKUP DATABASE [F47999] TO DISK = N'\\server2\g$\x\F47999.bak' WITH NOFORMAT, NOINIT, NAME = N'F47999-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
    Code (markup):
    Next I use a query on server 2:
    RESTORE DATABASE [F47999] FROM DISK = N'G:\x\F47999.bak' WITH FILE = 1, MOVE N'F47999Data' TO N'F:\MSSQL2\Visma\F47999.mdf', MOVE N'F47999Log' TO N'G:\MSSQL2\Visma\F47999_1.ldf', NORECOVERY, NOUNLOAD, STATS = 10
    Code (markup):
    Is it possible to have this in one query?
     
    kayo, Nov 21, 2009 IP