Log Shipping on Clustered SQL Server

Hi,
I'm trying to implement Log Shipping on a 2 Node SQL Cluster for certain
DB's.
As far as I understand, I've to share the folder where the transaction logs
are backed.
My questions are:
a) I cannot configure the DB to back the TRN's on a network drive, it says
"Not Allowed" The drive should be local to the SQL server.
b) If I create a share on the existing Drive where the TRN's are getting
back, that share will be lost if a failover occurs.
c) Is it like you've to write a script that will move the TRN's to a shared
Location.
I'd really appreciate any feedback on this.
Thanks a lot.
Vick
You can back up to a UNC network share.
HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/kb/555128
If you insist on storing the backup files to local cluster disks, you need
to create a separate file share that is a clustered resource. That way, any
instance can access it regardless of the current host node.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Vick Shaw" <nospam@.msft.com> wrote in message
news:eeJaOvdUHHA.1636@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I'm trying to implement Log Shipping on a 2 Node SQL Cluster for certain
> DB's.
> As far as I understand, I've to share the folder where the transaction
> logs
> are backed.
> My questions are:
> a) I cannot configure the DB to back the TRN's on a network drive, it says
> "Not Allowed" The drive should be local to the SQL server.
> b) If I create a share on the existing Drive where the TRN's are getting
> back, that share will be lost if a failover occurs.
> c) Is it like you've to write a script that will move the TRN's to a
> shared
> Location.
> I'd really appreciate any feedback on this.
> Thanks a lot.
> Vick
>
|||Thanks Geoff..
So which is the right way to do it. Should I back it to UNC or should I
create a separate file share?
Thanks again
Vick
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23pKfx7dUHHA.4744@.TK2MSFTNGP02.phx.gbl...
> You can back up to a UNC network share.
> HowTo: Backup to UNC name using Database Maintenance Wizard
> http://support.microsoft.com/kb/555128
> If you insist on storing the backup files to local cluster disks, you need
> to create a separate file share that is a clustered resource. That way,
any[vbcol=seagreen]
> instance can access it regardless of the current host node.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Vick Shaw" <nospam@.msft.com> wrote in message
> news:eeJaOvdUHHA.1636@.TK2MSFTNGP02.phx.gbl...
says
>
|||Hi Geoff,
When I tried to put a UNC in the TRN log file path it gave me an error:
Error:5110 \\domain\filename.ldf is on a network device not supported for
database files.
ALTER DATABSE failed...
"Vick Shaw" <nospam@.msft.com> wrote in message
news:OS77SMgUHHA.1212@.TK2MSFTNGP03.phx.gbl...[vbcol=seagreen]
> Thanks Geoff..
> So which is the right way to do it. Should I back it to UNC or should I
> create a separate file share?
> Thanks again
> Vick
>
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:%23pKfx7dUHHA.4744@.TK2MSFTNGP02.phx.gbl...
need[vbcol=seagreen]
> any
certain[vbcol=seagreen]
> says
getting
>
|||Slight misunderstanding.
I think you are trying to store an actual transaction log file, not a
transaction log backup, on a network share. At least, that is what the
error is reporting.
Which version of SQL are you using and what tool are you using? Can you
send the exact steps you are using to generate this error.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Vick Shaw" <nospam@.msft.com> wrote in message
news:uuJjFWgUHHA.1212@.TK2MSFTNGP03.phx.gbl...
> Hi Geoff,
> When I tried to put a UNC in the TRN log file path it gave me an error:
> Error:5110 \\domain\filename.ldf is on a network device not supported for
> database files.
> ALTER DATABSE failed...
> "Vick Shaw" <nospam@.msft.com> wrote in message
> news:OS77SMgUHHA.1212@.TK2MSFTNGP03.phx.gbl...
> need
> certain
> getting
>