Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Network Databases? Is it time to change? Expand / Collapse
Author
Message
Posted Monday, November 14, 2011 9:57 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:16 PM
Points: 31,284, Visits: 15,748
Comments posted to this topic are about the item Network Databases? Is it time to change?






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1205663
Posted Monday, November 14, 2011 10:37 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 1:10 AM
Points: 115, Visits: 1,023
What makes you so strongly say not to backup a SQL database across the network out of interest?

I've been doing this for a while myself, and found it very reliable in my environment and personally agree a lot with this article.

http://www.brentozar.com/archive/2008/09/back-up-your-database-to-the-network-not-local-disk/
Post #1205668
Posted Tuesday, November 15, 2011 6:22 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:21 AM
Points: 17,977, Visits: 15,981
Thanks for pointing out that new article about data files on network shares. That looks interesting and worth a shot.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1205901
Posted Tuesday, November 15, 2011 6:49 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, November 17, 2014 12:50 PM
Points: 13,872, Visits: 9,598
I haven't tried a data file on a network share yet.

On the other hand, data files on a SAN aren't really "local", but I have plenty of databases working that way.

As for network backups, I've been doing that for years.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1205932
Posted Tuesday, November 15, 2011 6:52 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 4:23 AM
Points: 20,584, Visits: 9,624
I do the backups locally, on a 2nd san. In a shared folder and then immediately kick in a test restore.


So I know right away if anything went wrong... which is the whole idea in backing up locally. Reduces backup corruption risks.
Post #1205940
Posted Tuesday, November 15, 2011 7:54 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:16 PM
Points: 31,284, Visits: 15,748
PhilipC (11/14/2011)
What makes you so strongly say not to backup a SQL database across the network out of interest?

I've been doing this for a while myself, and found it very reliable in my environment and personally agree a lot with this article.

http://www.brentozar.com/archive/2008/09/back-up-your-database-to-the-network-not-local-disk/


I have had it fail quite a few times in my career. If there is an issue over the network, then your backup fails, and any time savings are lost, and risk is increased. Perhaps if you have a very reliable network, at a 1Gbps speed, it works very well, but on 100Mbps switches, I've had it fail enough times to not consider it reliable.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1206013
Posted Tuesday, November 15, 2011 8:18 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 12:35 AM
Points: 80, Visits: 215
There is still an advantage to have local backup or should I say at least three disadvanteges to not to.
1. Network issues
2. Discs on the backup (3rd party)
3. Timehandling as this 3rd party backup software usually backs up everything else as well.

So not having local backup can get you wishing you have had.

I use local backup to discs connected to SQL server and then let 3rd party backup software take backup on those.

Very secure and nice if you need to restore quickly.
Post #1206047
Posted Tuesday, November 15, 2011 10:36 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 2:50 PM
Points: 1,937, Visits: 2,107
I've been setting up database backups to occur over the network for years. The primary reason is that not every company I go to has enough disk space directly attached to keep the number of backups they want. You definately don't want to store your backups on the same physical disks as your data or transaction log files. There was only one place I was at which had a problem backing up over the network, but it was mainly due to their low end NAS device. I changed their backup files to store locally then get moved to the NAS immediately after and that worked.

On the other hand, I think that network speed still has a long way to go before I'd consider putting any data or transaction log files on the network. Disk I/O is the slowest part of the equation typically, and network I/O will be slower yet.
Post #1206188
Posted Tuesday, November 15, 2011 12:00 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, October 27, 2014 8:55 AM
Points: 1,639, Visits: 1,985
We send transaction log backups directly to a network location to get them off the server. With the exception of one server that works well. For full and diff backups, those go to disk and then tape. One of the things in the works is a network location to store those backups and once that's set we'll have to find out if the network is more of a problem with the larger backup size. Based on what I've seen so far it wouldn't surprise me.
Post #1206232
Posted Tuesday, November 15, 2011 7:09 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, November 17, 2014 12:50 PM
Points: 13,872, Visits: 9,598
Steve Jones - SSC Editor (11/15/2011)
PhilipC (11/14/2011)
What makes you so strongly say not to backup a SQL database across the network out of interest?

I've been doing this for a while myself, and found it very reliable in my environment and personally agree a lot with this article.

http://www.brentozar.com/archive/2008/09/back-up-your-database-to-the-network-not-local-disk/


I have had it fail quite a few times in my career. If there is an issue over the network, then your backup fails, and any time savings are lost, and risk is increased. Perhaps if you have a very reliable network, at a 1Gbps speed, it works very well, but on 100Mbps switches, I've had it fail enough times to not consider it reliable.


I also had problems with it in the early 00s, with SQL 2k and 10-baseT networks. I think the first system I used that allowed reliable network database backups was in 2007, on SQL 2k5, 1 Gbs network, with small databases (none over 10 Gig, if even that).


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1206379
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse