Saturday, September 7, 2013

[SQL 2012] Offsite Backups

[SQL 2012] Offsite Backups

Offsite Backups

Posted: 06 Sep 2013 09:21 PM PDT

I have a client with a mission critical SQL Server serving local network and VPN users that wants offsite database backups. Compressed, the database backup is about 80MB, not huge, but big enough to cause a slow network some problems. I tried using Azure Storage and completing a demo to backup a very small database was easy to complete however the bandwidth requirements are quite steep so I had to abandon the effort. It worked out to need a minimum of 8 Megabit upload line-speed or else the backups would timeout. This particular client cannot be guaranteed those types of line speeds from their basic business-class internet provider. I [i]really[/i] like the way backing up to Azure Storage is integrated with the BACKUP DATABASE statement, but alas it seems like it was not meant for this project.For small businesses that have a SQL Server instance at a branch office and only a business class DSL or cable internet line, what would be the best offsite backup solution? So far I have looked at Azure Storage as mentioned and even using Microsoft SkyDrive (I know). Carbonite seems like a decent option but I read that even if you have a capable connection they severely throttle their bandwidth. Any guidance on a product or solution?

hihio

Posted: 06 Sep 2013 09:24 PM PDT

dthrft

Too Much Unused Space A Performance Issue?

Posted: 06 Sep 2013 11:33 AM PDT

Hi let me first say I know shrinking a Database is bad for fragmentation. What I want to know is with a very large database, does it cause a performance issue to have a lot of unused space. I'm talking about a 1.8 TB database with 475 GB of unused space.I ask this not because I want to shrink it, but because I want to avoid the manual file growth requirement (not set by me) to grow the data file when there is less than 20% free space.I'd prefer to configure auto growth at 8GB and let it roll which got me thinking about, "how does the amount of free space within a data file relate to performance"?Thanks!

multithreaded insert

Posted: 06 Sep 2013 09:00 AM PDT

Im aware of the usual way of getting a multi threaded/process insert by utilizing heaps or partitioned tables and multiple insert statements, but if inserting into a heap or partitioned table, is there any way that sql server query optimizer will make a single insert into a multi insert, assuming the destination fulfills all cryteria to allow bulk insert and the data is evenly distributed across all partitions etc?

Weird Behavior after Windows app Service terminated in NEW SQL Server 2012

Posted: 06 Sep 2013 05:44 AM PDT

Our SQL DBA just installed Windows SQL Server 2012 on our DEV server and we've started experiencing some weird behavior and needed some assistance. We have a Java application that is executed from starting up a Windows Service on our Windows Server 2012 box. When I'm in DEV I shut down this service and restart my application after code changes have been made. After I shutdown the windows service to kill my Java application one of the tables for some reason starts to reload its records. This same application sits on a Windows 2003 box and this behavior does NOT exist in SQL Server 2008. Any ideas on what is causing this issue or help on how to stop the table from reloading itself would be appreciated.:crazy:Thanks.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog