Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
obatard
Starting Member
1 Post |
 Posted - 2012-11-15 : 05:05:45
|
| 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
38200 Posts |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2012-11-16 : 09:11:51
|
| I bet you the answer will be "yes, one for each user on my website"- LumbagoMy blog-> http://thefirstsql.com |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-11-17 : 11:08:54
|
| 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 |
|
|
|
|
|
|
SQL Server backup thousand of databases