Sorry about that Simon, I guess I didn't clarify enough the first time.
When I perform a full backup I get errors on only LIVE DB files with an
"Unknown Error". I know that I can take the offline backup and restore
to SQL but I wanted to know if I can take a live backup without the SQL
Agent.
Sorry for any misunderstandings.
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:43 AM
To: Anas Kayal; veritas-bu at mailman.eng.auburn.edu
Subject: RE: [Veritas-bu] SQL Backup
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: Simon.Weaver at Astrium-eads.net
<mailto: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/sqlbackup
rest.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: Simon.Weaver at Astrium-eads.net
<mailto: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/bbffc049/attachment.htm
|