Re: Does NTBackup backup SQL Express?
- From: Daveinfla <Daveinfla@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 19 Jan 2008 17:53:00 -0800
Just an update, I was able to use the Studio Express Management Tool to
schedule backups of the SQL databases which were written to a backup
directory on the hard drive. These were the backed up to an external hard
drive as part of the nightly NTBackup process.
Dave
"Al Williams" wrote:
Not sure about SQL Express, I still use SQLserver 2000 so I can't help much.
there I'm afraid.
Googling a bit seems to indicate that backing up Express may not be as easy:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=487021&SiteID=1
Have you tried NTBACKUP with it (any errors or event logs)? Make sure you
have all the latest SP's for Windows/SBS and SQLExpress as NTBACKUP had some
updates.
--
Allan Williams
"Daveinfla" <Daveinfla@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:310DCFBE-86A1-43B2-B06E-A83F67639B82@xxxxxxxxxxxxxxxx
These databases, two of them, were setup by the vendors. How do I know
what
kind of install it is.
Do you have examples of what to look for and what .cmd file would look
like?
Dave
"Al Williams" wrote:
This depends upon the configured database model. For most databases it
is
set to "simple" so that log flushes are done automatically. For other
models you would have to backup and flush things manually.
Note if you create a .cmd file that does your flush/backup then you can
always schedule that.
--
Allan Williams
"Daveinfla" <Daveinfla@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E7F7F916-9050-4A15-8B45-2001016D50F6@xxxxxxxxxxxxxxxx
In which case I assume the logs do NOT get flushed so this is not an
option
as I know enough that the logs must be flushed during every full
backup.
There's a way to manually back the DB's thru Management Studio Express
but
I
can't figure out how to automate the process.
Thanks,
Dave
"Al Williams" wrote:
No, it's not listed separately. I *think* those backups are part of
the
shadow copy process and simply backup the open database files and logs
directly, like an offline backup (except they don't need to take the
DB
offline).
--
Allan Williams
"Brian Cryer" <brianc@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23jjN0o9OIHA.5160@xxxxxxxxxxxxxxxxxxxxxxx
Fascinating. Unfortunately I can't confirm it. (Love to be able to.)
The
servers I have with SQL Server on them are 2003 Standard (they don't
generate anything in the event log to indicate that they might be
covered
by ntbackup), and the SBS server I regularly use runs MySQL not SQL
Server.
If anyone could confirm this it would be great.
Allan, if you load the backup set does the database appear to be
listed
separately? I ask because if it is included then can it be selected
for
a
restore?
--
Brian Cryer
www.cryer.co.uk/brian
"Al Williams" <donotreplydirect@xxxxxxxxxxxxxxxx> wrote in message
news:u4ANd01OIHA.292@xxxxxxxxxxxxxxxxxxxxxxx
I'm using NTBACKUP, and whenever it backs up a volume using shadow
copy
it
always generates a MSSQLSERVER event 17055 in the app log for each
database
it encounters on that drive. This event is the same one generated
if
you
used the SQL Enterprise Manager to backup the database manually or
on
a
schedule. This implies NTBACKUP is automatically handling backing
up
SQL
or
MSDE databases but I've never gotten this confirmed. Do you see
those
events?
I still backup important DB's the old way just in case.
--
Allan Williams
"Brian Cryer" <brianc@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23MgKpJ1OIHA.2376@xxxxxxxxxxxxxxxxxxxxxxx
"Daveinfla" <Daveinfla@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:04D86498-0D5D-43A8-AC4B-8BA4EE94DA78@xxxxxxxxxxxxxxxx
I know NTBackup backs up SBSMONITORING and SHAREPOINT on SBS
Standard,
however is it capable of backing up SQL Express and flushing the
logs?
I'm not aware of any way to make NTbackup include a backup of an
SQL
Server database (although the above would hint that there ought to
be
a
way).
If not, how can this be down without buying something like Backup
Exec?
I've always scripted my SQL Server backups separatly. I wrote some
notes
about it ages ago (when I first moved from NT4 to 2000) -
http://www.cryer.co.uk/brian/sqlserver/howtofullw2ksql2000bkp.htm
-
whilst there are long-in-the-tooth and apply to SQL Server 2000
rather
than 2005 they should give you an idea on one way to proceed. You
may
find that there are a few subtle but important differences between
SQL
2000 and SQL Express, but I've not yet needed to look into backing
up
an
SQL Server express system.
Hope this helps.
--
Brian Cryer
www.cryer.co.uk/brian
- Prev by Date: Re: Reverse Lookup Zone Missing
- Next by Date: bkprunner
- Previous by thread: 70-282 exam - which SBS 2003version
- Next by thread: bkprunner
- Index(es):
Relevant Pages
|
