Backup over LAN or FC

#1

Hello,

I have two node A/A cluster, I backup all databases (from node 1 and node 2)
over the LAN network (1GB) to backup server (example BACKUP DATABASE DB1 TO
DISK = '\\BackupServer\Share' and so on), it is not so fast and secure way.
I'm using native SQL Server backup system.

I'd like change this and backup database over FC network, so I'm going to
add new disks to SAN Array, change MSCS and add new resource "File Share"
with PhysicalDisk, IPAdress, NetworkName and backup to "local" disk it should
be more faster.

I'm wondering about:

1. impact on other "PhysicalIDisk" resources, do you see any bottleneck in
this situation (where)?

2. in one time only one node can be owner of that resource "Backup", how
second node can get this resource (over \\NetworkName\Disk$ - this "share"
mean copy over LAN or over FC it is not clear for me ?)

Thanks in advance.

--
Regards,
anxcomp

#2

Hello,

"Mohit K. Gupta" wrote:

Quote:

Unless your backup server is outside your domain I don't think you should
worry about it from security point.

All my servers are in the same local AD domain.

Quote:

What you can do to make that share more secure is this:

1) Make the share a hidden share by using "$" after it.
2) Lock the share down so only SQL DBA/SQL Server Service account can access
it.
3) Lock down the physical folder so only SQL DAB/SQL Server Service account
can access it.

Thanks for tips.

Quote:

As for speed how slow is? How big of the database you are backing up?

All databases are about 100GB backup takes abut 3hours but databases still
growing and time will grow too.

Tell the truth time is on the second position at my problem list

first place take below problem:

-----------------------------------------------------------------------------------------------------------
BACKUP DATABASE - Operating system error 2 [5] [64](error not found).

http://www.microsoft.com/communities...=en-us&m=1&p=1
-----------------------------------------------------------------------------------------------------------

Unfortunately mapped drives not help I get randomly the same error message,
so this real reason I want change backup over LAN.

Quote:

The
thing you have to realize about putting backups on your cluster node is the
public network interface will get taxed when you backup from you second
active node to your primary active node for duration of the backup. If that
is not a big concern to you then it is a possible method.

If I well understand backup node2 over \\NetworkName\Disk$ (standalone group
on MSCS as I wrote on the first post) will go through public interfaces node2
and node1,
so in this case bottleneck still be LAN bandwidth ?

Quote:

You can also create two backup drives and give one to each active node so it
is only backup to its own drive and from there you tape backup picks it up.

I know it will be probably best way.

Quote:

Thanks.

"anxcomp" <anxcomp (AT) discussions (DOT) microsoft.com> wrote in message
news:506D0C52-ACC9-45BE-A038-186BC54C45A2 (AT) microsoft (DOT) com...
Hello,

I have two node A/A cluster, I backup all databases (from node 1 and node
2)
over the LAN network (1GB) to backup server (example BACKUP DATABASE DB1
TO
DISK = '\\BackupServer\Share' and so on), it is not so fast and secure
way.
I'm using native SQL Server backup system.

I'd like change this and backup database over FC network, so I'm going to
add new disks to SAN Array, change MSCS and add new resource "File Share"
with PhysicalDisk, IPAdress, NetworkName and backup to "local" disk it
should
be more faster.

I'm wondering about:

1. impact on other "PhysicalIDisk" resources, do you see any bottleneck in
this situation (where)?

2. in one time only one node can be owner of that resource "Backup", how
second node can get this resource (over \\NetworkName\Disk$ - this "share"
mean copy over LAN or over FC it is not clear for me ?)

Thanks in advance.

--
Regards,
anxcomp

--
Regards,
anxcomp

#3

Another option for you if you have budget on some tools; you can look at the
RedGate or LightSpeed backup tools.

I have yet to convince people to let me use them; but I have heard wonders
about these tools.

And I wouldn't put the drive in the Cluster configuration if you want to
back it up; then it will keep failing back and froward and you'll have to go
through DSN redirect to back it up; just attack it directly to Node 1, and
access it using \\Node1\BackupFolder$

Thanks.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

"anxcomp" wrote:

Quote:

Hello,

"Mohit K. Gupta" wrote:

Unless your backup server is outside your domain I don't think you should
worry about it from security point.

All my servers are in the same local AD domain.

What you can do to make that share more secure is this:

1) Make the share a hidden share by using "$" after it.
2) Lock the share down so only SQL DBA/SQL Server Service account can access
it.
3) Lock down the physical folder so only SQL DAB/SQL Server Service account
can access it.

Thanks for tips.

As for speed how slow is? How big of the database you are backing up?

All databases are about 100GB backup takes abut 3hours but databases still
growing and time will grow too.

Tell the truth time is on the second position at my problem list

first place take below problem:

-----------------------------------------------------------------------------------------------------------
BACKUP DATABASE - Operating system error 2 [5] [64](error not found).

http://www.microsoft.com/communities...=en-us&m=1&p=1
-----------------------------------------------------------------------------------------------------------

Unfortunately mapped drives not help I get randomly the same error message,
so this real reason I want change backup over LAN.

The
thing you have to realize about putting backups on your cluster node is the
public network interface will get taxed when you backup from you second
active node to your primary active node for duration of the backup. If that
is not a big concern to you then it is a possible method.

If I well understand backup node2 over \\NetworkName\Disk$ (standalone group
on MSCS as I wrote on the first post) will go through public interfaces node2
and node1,
so in this case bottleneck still be LAN bandwidth ?

You can also create two backup drives and give one to each active node so it
is only backup to its own drive and from there you tape backup picks it up.

I know it will be probably best way.

Thanks.

"anxcomp" <anxcomp (AT) discussions (DOT) microsoft.com> wrote in message
news:506D0C52-ACC9-45BE-A038-186BC54C45A2 (AT) microsoft (DOT) com...
Hello,

I have two node A/A cluster, I backup all databases (from node 1 and node
2)
over the LAN network (1GB) to backup server (example BACKUP DATABASE DB1
TO
DISK = '\\BackupServer\Share' and so on), it is not so fast and secure
way.
I'm using native SQL Server backup system.

I'd like change this and backup database over FC network, so I'm going to
add new disks to SAN Array, change MSCS and add new resource "File Share"
with PhysicalDisk, IPAdress, NetworkName and backup to "local" disk it
should
be more faster.

I'm wondering about:

1. impact on other "PhysicalIDisk" resources, do you see any bottleneck in
this situation (where)?

2. in one time only one node can be owner of that resource "Backup", how
second node can get this resource (over \\NetworkName\Disk$ - this "share"
mean copy over LAN or over FC it is not clear for me ?)

Thanks in advance.

--
Regards,
anxcomp

--
Regards,
anxcomp

#4

"Mohit K. Gupta" wrote:

Quote:

Another option for you if you have budget on some tools; you can look at the
RedGate or LightSpeed backup tools.

I have yet to convince people to let me use them; but I have heard wonders
about these tools.

Thanks, I like native backup but worst thing with native is missing
compression

I don't understand why MS include compression only in SQL 2008 EE, I think
it should be available in all editions.

--
Regards,
anxcomp

#5

I agree; in 2008 they have included alot of new functions but most are in EE.
I am not sure why didn't they spread them out a bit more.

You can look at RedGate backup or LightSpeed backup; both of these tools are
great for SQL Backups.

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

"anxcomp" wrote:

Quote:

"Mohit K. Gupta" wrote:

Another option for you if you have budget on some tools; you can look at the
RedGate or LightSpeed backup tools.

I have yet to convince people to let me use them; but I have heard wonders
about these tools.

Thanks, I like native backup but worst thing with native is missing
compression

I don't understand why MS include compression only in SQL 2008 EE, I think
it should be available in all editions.

--
Regards,
anxcomp

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Backup over LAN or FC

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Backup over LAN or FC - 03-22-2009 , 09:53 AM

Re: Backup over LAN or FC - 03-22-2009 , 03:39 PM

Re: Backup over LAN or FC - 03-23-2009 , 11:48 AM

Re: Backup over LAN or FC - 04-04-2009 , 05:15 PM

Re: Backup over LAN or FC - 04-05-2009 , 01:06 PM