-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|