Re: Does NTBackup backup SQL Express?

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: 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: New to Windows CE Development - Have some questions
    ... validating against the main database, or querying the database during data ... iterate through the SQL CE table and create new entries in the ... SQL Server database that correspond. ... >>> not connected to the Enterprise. ...
    (microsoft.public.windowsce.app.development)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • Re: Using Access 2007 to connect to SQL
    ... MDB database file format, ODBC linked tables, passthrough queries ... probably the easiest way of retrieving data from a SQL-Server ... I'm a total newbie w MS SQL Server. ...
    (microsoft.public.access.adp.sqlserver)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... MSDE to store SharePoint uses the MSSQL$SharePoint database, ... SharePoint named instance to full SQL. ... You cannot upgrade the Monitoring instance to SQL ... What I see is the SQL server group and under ...
    (microsoft.public.windows.server.sbs)