Michael Stowe wrote at about 16:37:36 -0500 on Monday, September 7, 2009:
> If you care to get your technical information from Microsoft rather than
> conjecture, there's considerable detail available here:
>
> http://technet.microsoft.com/en-us/library/cc966520.aspx
If you care to know that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Nigel Kendrick wrote:
>
> Our 700MB .bak files ZIP down to around 130MB and I was wondering
> whether it would be worth taking this offsite, but it may be that
> syncing the raw dumps may be quicker.
In my case it is definitely quicker... 550MB approx
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Les Mikesell wrote:
> Nigel Kendrick wrote:
>>
>> Thanks for the stats on ZIPped MS-SQL db files - that has saved me doing
>> some tests!
>
> I believe those stats use rsync -z which you can't do directly in backuppc.
Sorry, I should have mentioned th
> But anyway, using VSS does not assure a stable database state. You
> would at least need to 'sync' (or stop) the database to ensure such a
> state. Now in practice, the database may be robust and you may just
> lose the last entry but taking a VSS is not a recommended method.
Microsoft recommend
Michael Stowe wrote at about 14:05:52 -0500 on Monday, September 7, 2009:
> It's not necessary, so I don't bother.
>
> (The Volume Shadow Copy Service notifies the SQL Server writer to quiesce
> its data stores, so I/O is stopped during shadow copy creation. It's
> automatic.)
>
> > Do yo
Michael Stowe wrote at about 12:55:34 -0500 on Monday, September 7, 2009:
>
> I just use Volume Shadow Services to back up the whole thing at the file
> level -- neat, and consistent.
>
> > Hey,
> >
> > it's a litle bit off-topic, but can someone post his steps how to get a
> > dump of a
It's not necessary, so I don't bother.
(The Volume Shadow Copy Service notifies the SQL Server writer to quiesce
its data stores, so I/O is stopped during shadow copy creation. It's
automatic.)
> Do you stop the DB momentarily while making the shadow to make the files
consistent?
>
> --
>Les
Michael Stowe wrote:
> I just use Volume Shadow Services to back up the whole thing at the file
> level -- neat, and consistent.
Do you stop the DB momentarily while making the shadow to make the files
consistent?
--
Les Mikesell
lesmikes...@gmail.com
---
I just use Volume Shadow Services to back up the whole thing at the file
level -- neat, and consistent.
> Hey,
>
> it's a litle bit off-topic, but can someone post his steps how to get a
> dump of a MS SQL database? I have one DB here running with the Express
> version for one application and I'd
Nigel Kendrick wrote:
>
> Thanks for the stats on ZIPped MS-SQL db files - that has saved me doing
> some tests!
I believe those stats use rsync -z which you can't do directly in backuppc.
> I will eventually have to backup MS_SQL servers on 31 sites to a number of
> remote locations and so I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hey,
it's a litle bit off-topic, but can someone post his steps how to get a
dump of a MS SQL database? I have one DB here running with the Express
version for one application and I'd like to back it up properly.
Thanks,
Christian
Nigel Kendrick wr
Thanks for the stats on ZIPped MS-SQL db files - that has saved me doing
some tests!
I will eventually have to backup MS_SQL servers on 31 sites to a number of
remote locations and so I am currently experimenting with a number of
strategies.
At the moment, I am backing up as follows:
1) A nigh
On Sat, Sep 05, 2009 at 06:52:35PM -0600, dan wrote:
[...]
> You make a lot more sence here, but I think you overestimate CPU usage.
> backuppc is so IO bound that after your get a 2Ghz+ Dual core and 2GB RAM
> you can pretty much blame your disks for slow performance. I have a dual
> core 2Ghz
On Sat, Sep 05, 2009 at 06:35:16PM -0600, dan wrote:
[...]
> Thinking about the logistics in the method I have thought up a few hurdles.
> The source disks must remain unchanged during the entire sync.
> You would need to either have a spare disk in a raid1 mirror that you
> could remove from
On Mon, 7 Sep 2009 18:04:55 +1200, Michael wrote:
> Why not ext4?
> works very well on my setup
well, AFAIK, it also have a inode limit, but the max its too large
to be a problem...
yet, i dont know what default limit it have
but the main reason is the same: its t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have a remote machine which backs up a MS SQL DB and automatically
puts it into a dated zip file. I wrote a small script to move these
files to another directory where the new filename would have a number 0
- - 6 for the 7 days of the week (so there
16 matches
Mail list logo