hi,
is there a possibility do backup the transaction log to 2 different
locations, and to handle them separatly when restoring a database?
The thing i want to do is, to be able to restore the database on 2
different location without doing logshipping.
thx for your help.
Hi
No. After the backup, do a XCOPY to the alternative location.
Regards
Mike
"Donald" wrote:
> hi,
> is there a possibility do backup the transaction log to 2 different
> locations, and to handle them separatly when restoring a database?
> The thing i want to do is, to be able to restore the database on 2
> different location without doing logshipping.
> thx for your help.
>
|||When I've done this I've always implemented it as an external app (VB
based). Not too hard to do.
"Donald" <martin.ha@.gmx.net> wrote in message
news:enCcG$QDFHA.3732@.TK2MSFTNGP14.phx.gbl...
> hi,
> is there a possibility do backup the transaction log to 2 different
> locations, and to handle them separatly when restoring a database?
> The thing i want to do is, to be able to restore the database on 2
> different location without doing logshipping.
> thx for your help.
Showing posts with label location. Show all posts
Showing posts with label location. Show all posts
Sunday, February 12, 2012
Backup Transaction Log to 2 different location
hi,
is there a possibility do backup the transaction log to 2 different
locations, and to handle them separatly when restoring a database?
The thing i want to do is, to be able to restore the database on 2
different location without doing logshipping.
thx for your help.Hi
No. After the backup, do a XCOPY to the alternative location.
Regards
Mike
"Donald" wrote:
> hi,
> is there a possibility do backup the transaction log to 2 different
> locations, and to handle them separatly when restoring a database?
> The thing i want to do is, to be able to restore the database on 2
> different location without doing logshipping.
> thx for your help.
>|||When I've done this I've always implemented it as an external app (VB
based). Not too hard to do.
"Donald" <martin.ha@.gmx.net> wrote in message
news:enCcG$QDFHA.3732@.TK2MSFTNGP14.phx.gbl...
> hi,
> is there a possibility do backup the transaction log to 2 different
> locations, and to handle them separatly when restoring a database?
> The thing i want to do is, to be able to restore the database on 2
> different location without doing logshipping.
> thx for your help.
is there a possibility do backup the transaction log to 2 different
locations, and to handle them separatly when restoring a database?
The thing i want to do is, to be able to restore the database on 2
different location without doing logshipping.
thx for your help.Hi
No. After the backup, do a XCOPY to the alternative location.
Regards
Mike
"Donald" wrote:
> hi,
> is there a possibility do backup the transaction log to 2 different
> locations, and to handle them separatly when restoring a database?
> The thing i want to do is, to be able to restore the database on 2
> different location without doing logshipping.
> thx for your help.
>|||When I've done this I've always implemented it as an external app (VB
based). Not too hard to do.
"Donald" <martin.ha@.gmx.net> wrote in message
news:enCcG$QDFHA.3732@.TK2MSFTNGP14.phx.gbl...
> hi,
> is there a possibility do backup the transaction log to 2 different
> locations, and to handle them separatly when restoring a database?
> The thing i want to do is, to be able to restore the database on 2
> different location without doing logshipping.
> thx for your help.
Backup Transaction Log to 2 different location
hi,
is there a possibility do backup the transaction log to 2 different
locations, and to handle them separatly when restoring a database?
The thing i want to do is, to be able to restore the database on 2
different location without doing logshipping.
thx for your help.Hi
No. After the backup, do a XCOPY to the alternative location.
Regards
Mike
"Donald" wrote:
> hi,
> is there a possibility do backup the transaction log to 2 different
> locations, and to handle them separatly when restoring a database?
> The thing i want to do is, to be able to restore the database on 2
> different location without doing logshipping.
> thx for your help.
>|||When I've done this I've always implemented it as an external app (VB
based). Not too hard to do.
"Donald" <martin.ha@.gmx.net> wrote in message
news:enCcG$QDFHA.3732@.TK2MSFTNGP14.phx.gbl...
> hi,
> is there a possibility do backup the transaction log to 2 different
> locations, and to handle them separatly when restoring a database?
> The thing i want to do is, to be able to restore the database on 2
> different location without doing logshipping.
> thx for your help.
is there a possibility do backup the transaction log to 2 different
locations, and to handle them separatly when restoring a database?
The thing i want to do is, to be able to restore the database on 2
different location without doing logshipping.
thx for your help.Hi
No. After the backup, do a XCOPY to the alternative location.
Regards
Mike
"Donald" wrote:
> hi,
> is there a possibility do backup the transaction log to 2 different
> locations, and to handle them separatly when restoring a database?
> The thing i want to do is, to be able to restore the database on 2
> different location without doing logshipping.
> thx for your help.
>|||When I've done this I've always implemented it as an external app (VB
based). Not too hard to do.
"Donald" <martin.ha@.gmx.net> wrote in message
news:enCcG$QDFHA.3732@.TK2MSFTNGP14.phx.gbl...
> hi,
> is there a possibility do backup the transaction log to 2 different
> locations, and to handle them separatly when restoring a database?
> The thing i want to do is, to be able to restore the database on 2
> different location without doing logshipping.
> thx for your help.
Friday, February 10, 2012
Backup to networkdrive possible?
I can only see my local drive(s). I have mapped 2 networkshares but
can't see them when trying to choose a location for my backup. Can a
filebackup be made directly to a mapped (or non-mapped) networklocation?
Tnx,
Hans Brouwer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Yes. You must manually type the UNC name for the target. Do not use drive
mappings since SQL may not know about them. Also, the SQL service account
must have rights to write files in the target directory.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"hansje" <hansjes@.anonymous.com> wrote in message
news:OFVHba0rDHA.2456@.TK2MSFTNGP12.phx.gbl...
> I can only see my local drive(s). I have mapped 2 networkshares but
> can't see them when trying to choose a location for my backup. Can a
> filebackup be made directly to a mapped (or non-mapped) networklocation?
> Tnx,
> Hans Brouwer
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Hi ,
To add on to geoff's mail.
You can map the drive and use it in Query Analyzer along with Backup
statement.
Say your network server name FINANCE and the drive is k$ then use the below
statement to backup,
Backup database HRMS to disk='\\FINANCE\k$\MSSQL\BACKUP\HRMS_BACKUP.BAK with
init
The below statement will succed provided you have rights on that drive.
Thanks
Hari
MCDBA
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:#vUJ$e0rDHA.2084@.TK2MSFTNGP12.phx.gbl...
> Yes. You must manually type the UNC name for the target. Do not use
drive
> mappings since SQL may not know about them. Also, the SQL service account
> must have rights to write files in the target directory.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
>
>
> "hansje" <hansjes@.anonymous.com> wrote in message
> news:OFVHba0rDHA.2456@.TK2MSFTNGP12.phx.gbl...
> > I can only see my local drive(s). I have mapped 2 networkshares but
> > can't see them when trying to choose a location for my backup. Can a
> > filebackup be made directly to a mapped (or non-mapped) networklocation?
> >
> > Tnx,
> >
> > Hans Brouwer
> >
> > *** Sent via Developersdex http://www.developersdex.com ***
> > Don't just participate in USENET...get rewarded for it!
>
can't see them when trying to choose a location for my backup. Can a
filebackup be made directly to a mapped (or non-mapped) networklocation?
Tnx,
Hans Brouwer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Yes. You must manually type the UNC name for the target. Do not use drive
mappings since SQL may not know about them. Also, the SQL service account
must have rights to write files in the target directory.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"hansje" <hansjes@.anonymous.com> wrote in message
news:OFVHba0rDHA.2456@.TK2MSFTNGP12.phx.gbl...
> I can only see my local drive(s). I have mapped 2 networkshares but
> can't see them when trying to choose a location for my backup. Can a
> filebackup be made directly to a mapped (or non-mapped) networklocation?
> Tnx,
> Hans Brouwer
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Hi ,
To add on to geoff's mail.
You can map the drive and use it in Query Analyzer along with Backup
statement.
Say your network server name FINANCE and the drive is k$ then use the below
statement to backup,
Backup database HRMS to disk='\\FINANCE\k$\MSSQL\BACKUP\HRMS_BACKUP.BAK with
init
The below statement will succed provided you have rights on that drive.
Thanks
Hari
MCDBA
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:#vUJ$e0rDHA.2084@.TK2MSFTNGP12.phx.gbl...
> Yes. You must manually type the UNC name for the target. Do not use
drive
> mappings since SQL may not know about them. Also, the SQL service account
> must have rights to write files in the target directory.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
>
>
> "hansje" <hansjes@.anonymous.com> wrote in message
> news:OFVHba0rDHA.2456@.TK2MSFTNGP12.phx.gbl...
> > I can only see my local drive(s). I have mapped 2 networkshares but
> > can't see them when trying to choose a location for my backup. Can a
> > filebackup be made directly to a mapped (or non-mapped) networklocation?
> >
> > Tnx,
> >
> > Hans Brouwer
> >
> > *** Sent via Developersdex http://www.developersdex.com ***
> > Don't just participate in USENET...get rewarded for it!
>
Backup to Location over VPN
Hi,
I am having problems with creating a backup onto a machine that is connected to the domain via a VPN connection.
When i do the back up it does not recognize the directory that I have specified, yet when i use Windows explorer I can copy and paste to my hearts content.
I was just wondering if the backup of a database can be done to a location over a VPN.
Thanks in Advance
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Backups are done under the account that SQL Server runs under, not the
account you are using when you log in to QA or EM. SQL Server is most
likely running under the local service account which knows nothing of the
VPN or the Domain.
Andrew J. Kelly SQL MVP
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uhIiucxbEHA.252@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am having problems with creating a backup onto a machine that is
connected to the domain via a VPN connection.
> When i do the back up it does not recognize the directory that I have
specified, yet when i use Windows explorer I can copy and paste to my hearts
content.
> I was just wondering if the backup of a database can be done to a location
over a VPN.
> Thanks in Advance
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
I am having problems with creating a backup onto a machine that is connected to the domain via a VPN connection.
When i do the back up it does not recognize the directory that I have specified, yet when i use Windows explorer I can copy and paste to my hearts content.
I was just wondering if the backup of a database can be done to a location over a VPN.
Thanks in Advance
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Backups are done under the account that SQL Server runs under, not the
account you are using when you log in to QA or EM. SQL Server is most
likely running under the local service account which knows nothing of the
VPN or the Domain.
Andrew J. Kelly SQL MVP
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uhIiucxbEHA.252@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am having problems with creating a backup onto a machine that is
connected to the domain via a VPN connection.
> When i do the back up it does not recognize the directory that I have
specified, yet when i use Windows explorer I can copy and paste to my hearts
content.
> I was just wondering if the backup of a database can be done to a location
over a VPN.
> Thanks in Advance
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
Backup to Location over VPN
Hi,
I am having problems with creating a backup onto a machine that is connected
to the domain via a VPN connection.
When i do the back up it does not recognize the directory that I have specif
ied, yet when i use Windows explorer I can copy and paste to my hearts conte
nt.
I was just wondering if the backup of a database can be done to a location o
ver a VPN.
Thanks in Advance
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.Backups are done under the account that SQL Server runs under, not the
account you are using when you log in to QA or EM. SQL Server is most
likely running under the local service account which knows nothing of the
VPN or the Domain.
Andrew J. Kelly SQL MVP
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uhIiucxbEHA.252@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am having problems with creating a backup onto a machine that is
connected to the domain via a VPN connection.
> When i do the back up it does not recognize the directory that I have
specified, yet when i use Windows explorer I can copy and paste to my hearts
content.
> I was just wondering if the backup of a database can be done to a location
over a VPN.
> Thanks in Advance
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
I am having problems with creating a backup onto a machine that is connected
to the domain via a VPN connection.
When i do the back up it does not recognize the directory that I have specif
ied, yet when i use Windows explorer I can copy and paste to my hearts conte
nt.
I was just wondering if the backup of a database can be done to a location o
ver a VPN.
Thanks in Advance
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.Backups are done under the account that SQL Server runs under, not the
account you are using when you log in to QA or EM. SQL Server is most
likely running under the local service account which knows nothing of the
VPN or the Domain.
Andrew J. Kelly SQL MVP
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uhIiucxbEHA.252@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am having problems with creating a backup onto a machine that is
connected to the domain via a VPN connection.
> When i do the back up it does not recognize the directory that I have
specified, yet when i use Windows explorer I can copy and paste to my hearts
content.
> I was just wondering if the backup of a database can be done to a location
over a VPN.
> Thanks in Advance
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
Subscribe to:
Posts (Atom)