This topic has been archived. It cannot be replied.
-
工作学习 / 专业技术讨论 / hi guys, who may know how to backup one SQL Server Database to multiple pieces instead
of one backup file. Please give a hand on it. I'm a newbie to SQL Server.
-fxid(民工模范);
2006-6-23
(#3043502@0)
-
redgate has a pretty decent tool -SQL Backup, it can compress the database and backup "faster"
-canadiantire(轮胎-cui bono?);
2006-6-23
(#3043512@0)
-
i could not install any un-licensed software on my server. this is the issue.
-fxid(民工模范);
2006-6-23
(#3043532@0)
-
They have trial version.
-canadiantire(轮胎-cui bono?);
2006-6-23
(#3043541@0)
-
This SQL Backup is really what you want, it can split the backup file into multiple files, check this out
-canadiantire(轮胎-cui bono?);
2006-6-23
(#3043543@0)
-
I will suggest my employer to think about this tool as an alternative. Thank you very much for
the help.
-fxid(民工模范);
2006-6-23
(#3043677@0)
-
the question is why do you want to backup it into multiple pieces?
-holdon(again);
2006-6-23
(#3043516@0)
-
ok, one database backup piece over 4G, could not be compressed by winzip.
-fxid(民工模范);
2006-6-23
(#3043529@0)
-
If possible, spread your db to the different filegroups and then backup those files.
-yangn(Raymond);
2006-6-23
(#3043535@0)
-
another way is to just create multiple backup devices and backup your db to them. SQL Server will spread the backup over those devices for you.
-yangn(Raymond);
2006-6-23
(#3043547@0)
-
i'll try this first.
-fxid(民工模范);
2006-6-23
(#3043561@0)
-
tons of thanks for Raymond's help here. What I did is defined 2 pieces of backup destinations in Normal backup function. And the data has been seperated into 2 files with
equal size. Fixed things.
-fxid(民工模范);
2006-6-23
(#3043672@0)
-
u r welcome.
-yangn(Raymond);
2006-6-23
(#3044576@0)
-
This is a good suggestion.
-iwantcar(流浪的EnjoyStudying);
2006-6-23
(#3043569@0)
-
how about use gzip.exe?
-647i(流浪的步行万里);
2006-6-23
(#3044609@0)
-
if the compress utility/prgram is stream based, there is no size limit, unless the filesystem has file size limit. gzip can be use as stream based compresser, with -c option.
-647i(流浪的步行万里);
2006-6-23
(#3044615@0)
-
if for this sake, use WinRAR.
-bdbs(不多不少);
2006-6-23
(#3044632@0)
-
Seem not difficult. How about I write one for you? should be in the price of 1000dollar. en, I am not very sure if I have time. My own small database system is already exceeded 4G.my c codes handle a lot of file more than 4G everyday .
-iwantcar(流浪的EnjoyStudying);
2006-6-23
{55}
(#3043558@0)