Re: Does NTBackup backup SQL Express?


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













.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... with volume Shadow Copy error 800423f4. ... You back up data from a volume that contains a Microsoft SQL Server ... The recovery model of the SQL Server database is configured to use an ... It just ensures backup will continue without reporting the error. ...
    (microsoft.public.windows.server.sbs)
  • Re: Does NTBackup backup SQL Express?
    ... like an offline backup (except they don't need to take the DB ... and the SBS server I regularly use runs MySQL not SQL ... if you load the backup set does the database appear to be listed ... I've always scripted my SQL Server backups separatly. ...
    (microsoft.public.windows.server.sbs)
  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: How do i move an SQLDatabase to another location?
    ... I went to my clients and installed SQL Server ... Express and copied my database to the same location it was in while i was ... knowing that i can bring a database with me and install ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Enterprise Manager Newbie Question
    ... a SQL backup is not a simple copy of the database files. ... Is it possible to write a script that one could run from a workstation and ...
    (microsoft.public.sqlserver.tools)