Re: Does NTBackup backup SQL Express?


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: SQL backup questions
    ... I support the Professional Association for SQL Server ... Copy DB is functionally the same as Backup and Restore. ...
    (microsoft.public.sqlserver.server)
  • Re: Conflicting SQL Client Settings
    ... creating an ALIAS in SQL tools for the different application would allow ... MCMS Blog: http://blogs.msdn.com/stefan_gossner/category/4983.aspx ... > Seems like SQL Server 2000 likes SQL Client to use TCP/IP (when doing ... > Server side SDO to export the CMS repository (as a backup, ...
    (microsoft.public.sqlserver.server)
  • Re: URGENT: SQL 6.5 Server Crash
    ... > Are these database backup done by SQL Server? ... > Or file backups performed by some Windows backup software? ... were they performed while SQL Server was running? ...
    (microsoft.public.sqlserver.server)
  • 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)
  • Re: Does NTBackup backup SQL Express?
    ... as I know enough that the logs must be flushed during every full backup. ... 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)