How was I to know this? If you are doing offline SQL Backups, then surely
when you run the "FULL BACKUPS" via NetBackup, you are capturing the .bak
files ??
If you have these files on tape, you use them to restore !
Am I missing something here??
Even if you were to do a FULL RESTORE of SQL, you have to restore the OS,
drives, partitions, ect and then once completed, recover SQL Server (be that
via the Online SQL Agent or offline using the restore method built into
SQL).
Bit puzzled by what you are asking.... if you want to do online sql backups,
use an agent and get licensed for it !
Regards
Simon Weaver
3rd Line Technical Support
Windows Domain Administrator
EADS Astrium Limited, B23AA IM (DCS)
Anchorage Road, Portsmouth, PO3 5PU
Email: <mailto:Simon.Weaver at Astrium-eads.net> Simon.Weaver at
Astrium-eads.net
-----Original Message-----
From: Anas Kayal [mailto:anas at up.org.qa]
Sent: 10 April 2007 08:38
To: veritas-bu at mailman.eng.auburn.edu
Subject: Re: [Veritas-bu] SQL Backup
Simon,
I do use that already and backup offline but i would rather do everything
from one place.
Best regards,
Anas Kayal
System Administrator
IT Department
Urban Planning and Development Authority
Office: +974-495-5170
Mobile: +974-534-2454
_____
From: WEAVER, Simon (external) [mailto:simon.weaver at astrium.eads.net]
Sent: Tuesday, April 10, 2007 10:36 AM
To: Anas Kayal; veritas-bu at mailman.eng.auburn.edu
Subject: RE: [Veritas-bu] SQL Backup
Anas
What about configuring an offline SQL Backup, via the SQL GUI application?
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest
.mspx#EOE
<http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackupres
t.mspx#EOE>
Does this help? no license needed .... and NetBackup will treat them as
backup files (.bak) - They are not in use, and you should get no problems !
WARNING: Offline Backups may not suit everyone. Therefore, if you are
running a large enterprise SQL environment, you may wish to invest in an
online, trouble free solution
Regards
Simon Weaver
3rd Line Technical Support
Windows Domain Administrator
EADS Astrium Limited, B23AA IM (DCS)
Anchorage Road, Portsmouth, PO3 5PU
Email: <mailto:Simon.Weaver at Astrium-eads.net> Simon.Weaver at
Astrium-eads.net
-----Original Message-----
From: Anas Kayal [mailto:anas at up.org.qa]
Sent: 10 April 2007 08:30
To: veritas-bu at mailman.eng.auburn.edu
Subject: [Veritas-bu] SQL Backup
Greetings All,
Is there anyway to properly backup SQL without a SQL license? Im running NBU
6 with MP4 and I take full backups. I take all local drives and system
state. I did a test restore yesterday but I didn't get all my DB's back.
There were some "Unknown Errors" during the initial backup.
Any Ideas?
Best regards,
Anas
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.
---------------------------------------------------------------------
Astrium Limited, Registered in England and Wales No. 2449259
Registered Office: Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS,
England
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.
---------------------------------------------------------------------
Astrium Limited, Registered in England and Wales No. 2449259
Registered Office: Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://mailman.eng.auburn.edu/pipermail/veritas-bu/attachments/20070410/d34c1fb9/attachment.html
|