Post reply

BACKUP

  • May 25, 2005 at 12:59 am

    #109845

    dear ALL

    i am having problem in database backup. i am having sql server 7.0 on windows NT 4. i am having backup jobs for 5 times in a day. my problem is that i want to take a autobackup on another computer . but i am not able to do that as backup device is on the server. pls. help .

    sachin

  • May 25, 2005 at 7:12 am

    #560940

    You can backup to a drive on any server using a UNC path.  Create a backup device of DISK='\\servername\share'

  • May 25, 2005 at 10:11 pm

    #561127

    hi

    thanks for the reply but i am having only one server and i want to take a backup on node . i am mapped drive on the server but it is not visible while creating a backup device

    pls help

    sachin

  • May 26, 2005 at 12:33 am

    #561137

    Hi Sachin,

    Use Dbcc Trace on(1807) in the T-sql and specify the shared path for the backup.Just like this

    use master

    go

    DBCC TRACEON(1807)

    GO

    BACKUP DATABASE Northwind

    TO Disk = '\\Machine_name\C$\Northwnd.bak

    Hope this will Work for you

    B John

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply