dcsimg
Results 1 to 3 of 3

Thread: Can I store a Sql Server tran-log & DB backups on another box

  1. #1
    Join Date
    Jul 2016
    Posts
    2

    Can I store a Sql Server tran-log & DB backups on another box

    Hi
    I am new to Sql Server database administration, my background is DB2 DBA on the mainframe.
    My senior Sql DBA is on leave, and I have a request to setup backups for a Sql Server 2012 Dev system, and store
    them on another box, my immediate thought was that I should be able to do that, providing the
    sysadmin acct. which will run the backups has authority to save data on the target box.
    Would that be correct ?

    Also in case a restore is required, then I would have to copy the tran-log & DB backups, back to the box where the database
    is, & then do the restore, would that be right ?

    Appreciate any feedback & advise.

    Many thanks in advance.

    John

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,913
    Yes you can. You need to run SQL Server services under domain account and grant read/write access to the file share you create on another server. You can use UNC path for backup/restore location.

  3. #3
    Join Date
    Jul 2016
    Posts
    2
    Many thanks Skhanal.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •