SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL Server backup thousand of databases
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

obatard
Starting Member

1 Posts

Posted - 11/15/2012 :  05:05:45  Show Profile  Reply with Quote
Hi,

I have sql server 2008 r2 on a cluster. The problem is I can't backup the server correctly because the server contains 17000 bases and the backup plan takes over 20 hours. Replication and mirorring doesn't work too.

Anyway what is the best way to backup faster that server ? Is there any tool for that ?

Thanks ?

tkizer
Almighty SQL Goddess

USA
37287 Posts

Posted - 11/15/2012 :  14:34:06  Show Profile  Visit tkizer's Homepage  Reply with Quote
You have 17,000 databases on a single SQL Server instance?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 11/16/2012 :  09:11:51  Show Profile  Reply with Quote
I bet you the answer will be "yes, one for each user on my website"

- Lumbago
My blog-> http://thefirstsql.com
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37287 Posts

Posted - 11/16/2012 :  11:58:48  Show Profile  Visit tkizer's Homepage  Reply with Quote
My limit for a single instance is 50 as I get worried about job durations. My databases aren't tiny or small. Plus I hate scrolling down a database list in SSMS. Heck, my personal limit is probably more like 20, lol. 17000 would make me go insane.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2075 Posts

Posted - 11/17/2012 :  11:08:54  Show Profile  Visit jackv's Homepage  Reply with Quote
Are you backing up straight to tape? How much is it in terms of disk space? To narrow your backup window you may need to investigate some snapshot technology - such as FlashCopy Manager . This depends on the stotrage type.


Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000