Re: Does NTBackup backup SQL Express?

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: 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)
  • Re: Does NTBackup backup SQL Express?
    ... schedule backups of the SQL databases which were written to a backup ... models you would have to backup and flush things manually. ... if you load the backup set does the database appear to be ... I've always scripted my SQL Server backups separatly. ...
    (microsoft.public.windows.server.sbs)