hi all
On Thu, 10 Sep 2009 12:04:09 +0100, "Nigel Kendrick"
wrote:
> domain DOS command called WHAT.COM that returns ERRORLEVEL set to 0-6
> according to the day of week.
we use the cygwin gnu date in several scripts, its a lot more
useful
gdate -d "last week" +%a\\%Y-%m-%d
Hi Folks,
Lively conversation!!
A while back, someone asked how the SQL backups are being done - here's my
take:
Two batch files, two stored procedures and a few command line tools.
* The stored procedures were written by an unknown person. One makes a dump
of the given database and verifies it
Michael Stowe wrote at about 08:27:54 -0500 on Tuesday, September 8, 2009:
> > 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 h
> But even for MS SQL server, it seemed to be a version-specific feature
> and not everyone runs the latest version. Your link also points out
> that a recovery procedure is necessary after a restore.
That's mostly correct on both counts -- it depends on which version of
Windows, SQL Server, and
Michael Stowe wrote:
>> 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/cc
> 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
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
-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
19 matches
Mail list logo
