Veritas-bu

Re: [Veritas-bu] Backing up SQL Express

2009-09-30 03:05:45
Subject: Re: [Veritas-bu] Backing up SQL Express
From: "WEAVER, Simon \(external\)" <simon.weaver AT astrium.eads DOT net>
To: <J.Keating AT tachi-s DOT com>, <veritas-bu AT mailman.eng.auburn DOT edu>
Date: Wed, 30 Sep 2009 07:41:18 +0100
Morning John
You do need a SQL License on the Master, and the Policy must be a SQL application policy for the backup.
 
Failing this, you can configure SQL Server to do "offline" backups to a flatfile on a local or Network drive. Then NetBackup treats it as a single file and backs the file up normally.
Just bear in mind that there are some limitations on backups and recovery with NBU and SQL Server Express, one of them being partial backups not being fully supported, due to limitations in SQL Express.
 
However, I do believe its covered in the SQL Admin Guide. It can also be found here if it helps...
 
 
Simon


From: veritas-bu-bounces AT mailman.eng.auburn DOT edu [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of J.Keating AT tachi-s DOT com
Sent: Tuesday, September 29, 2009 8:43 PM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] Backing up SQL Express


Hello All;

After recieving "operation not allowed during this time period(199)" errors while trying to backup an SQL 2005 Express database. I'm assuming that Veritas NBU 6.5.4 will not backup SQL Express.

Would me my assumption be correct?

Regards,
John Keating
Information Technology
Tachi-S Engineering U.S.A. Inc.
This email (including any attachments) may contain confidential
and/or privileged information or information otherwise protected
from disclosure. If you are not the intended recipient, please
notify the sender immediately, do not copy this message or any
attachments and do not use it for any purpose or disclose its
content to any person, but delete this message and any attachments
from your system. Astrium disclaims any and all liability if this
email transmission was virus corrupted, altered or falsified.
-o-
Astrium Limited, Registered in England and Wales No. 2449259
Registered Office:
Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
<Prev in Thread] Current Thread [Next in Thread>