| Author |
Topic |
|
cosy
Starting Member
22 Posts |
 Posted - 2008-06-08 : 06:28:43
|
| HI All, Bit confuse and please help to setup correct way of backup. I got SQL Server 2000 and Veritas Backupexec 10.0 So what is your recommended way to backup SQL Servers. 1. Veritas Backup agent with Differtial (Mon-Thu) and full backup on Friday? Set SQL recovery Model to FULL and only backup Transaction (.TRN) logs to server disk , No backup (.bak) from MP ? or 2. Create SQL MP and backup to SQL Server DB & Logs to disk every night- full backup Keep only 1 day worth of backup. ( not enough space) Use veritas to backup .bak file only not using that veritas SQL Backup? Or knowledge me with the proper method? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-08 : 14:43:35
|
| I'll go to second option since those third party windows backup tools don't handle sql backup properly, at least in my experience. |
 |
|
|
cosy
Starting Member
22 Posts |
Posted - 2008-06-11 : 03:12:29
|
| HI, Any Ideas guys? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-11 : 03:50:45
|
| I would also go with the second option, dislike backup exec enough not to fully trust it and seen it cause issues during production hours enough times to not let it near the databases. |
|
|
|
cosy
Starting Member
22 Posts |
Posted - 2008-06-11 : 19:27:38
|
| HI Rick, But the Problem is i got only Drive space with 500GB. My Data and Logs are nearly 230GB then Backup/Trans files are 230GB. Even if i set to keep 1 day worth of data the jobs failed due to lack of space?So thats why i want to know how people setup backup for large databases?is everyone use full database backup everyday? i mean .bak file?So what can we do with Verits SQL Agent? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-11 : 19:42:38
|
| For large databases, we use SQL Litespeed to back them up. You'll not only save a ton of disk space, but it'll also backup faster. Plus you don't have to rely on the people who support the Veritas portion as SQL Litespeed uses extended stored procedures, so it is handled by the DBA.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-12 : 01:28:52
|
| I would go with Litespeed as well, great tool.http://www.quest.com/litespeed-for-sql-server/ |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-06-12 : 12:11:53
|
| Drives are dirt cheap. Get another one for storing your backups.Don't use veritas for directly backing up your database files. Back them up through SQL Server's utilities, and then use Veritas to archive the backup files and log dumps.e4 d5 xd5 Nf6 |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-14 : 18:13:05
|
| Or backup db to tape with sql backup. |
|
|
|
cosy
Starting Member
22 Posts |
Posted - 2008-06-15 : 04:02:53
|
| Hi, Thanks all, But if we going to use tape then we can use the veritas? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-15 : 19:49:01
|
| I'll still step away from it. |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-06-16 : 10:52:40
|
| No, but if you are going to ignore us, then you can use Veritas.e4 d5 xd5 Nf6 |
|
|
|
cosy
Starting Member
22 Posts |
Posted - 2008-06-17 : 20:17:30
|
| HI Guys, No i'm not going to ignor you guys. OK So i'm going to Step 2.I can't buy any software for SQL Backup. But i'm going to do MP and use Veritas to Backup SQL.bak and *.Trn.If i'm not going to use veritas backup do i need to set the recovery model to Simple? atm it's set to full because veritas need that. |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-06-18 : 10:03:15
|
| YOU DON'T NEED TO BUY ANY SOFTWARE FOR SQL SERVER BACKUP! IT'S BUILT-IN!!!!!AAAAARRRRRGHHH!e4 d5 xd5 Nf6 |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-06-18 : 12:26:07
|
quote:
Originally posted by cosy
HI Guys, No i'm not going to ignor you guys. OK So i'm going to Step 2.I can't buy any software for SQL Backup. But i'm going to do MP and use Veritas to Backup SQL.bak and *.Trn.If i'm not going to use veritas backup do i need to set the recovery model to Simple? atm it's set to full because veritas need that.
I know that's not true. I do full backups of databases in "simple" mode using NetBackup. You cannot, however, backup transaction logs of databases set to "simple" mode. So it all depends on your strategy. How much data can you afford to lose if the system crashes and burns??Terry |
|
|
|
cosy
Starting Member
22 Posts |
Posted - 2008-06-22 : 20:52:34
|
| HI All, OK, Now i'm confuse with Simple and Full recovery model.To Backup SQL Server properley. is that the way or help me. 1. Set all DB's to Simple Recovery Model 2. Set MP to backup Transaction every 10 min and full Backup every night 2 AM 3. Use veritas to backup SQL.Bak & *.trn at 3 AM |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-22 : 22:34:25
|
| You have to set recovery model to full or bulk-logger to backup log. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-23 : 01:42:40
|
quote:
Originally posted by cosy
HI All, OK, Now i'm confuse with Simple and Full recovery model.To Backup SQL Server properley. is that the way or help me. 1. Set all DB's to Simple Recovery Model 2. Set MP to backup Transaction every 10 min and full Backup every night 2 AM 3. Use veritas to backup SQL.Bak & *.trn at 3 AM
Try reading the replies. If you look in BOL (Books Online [SQL Servers help file]) and you put BACKUP in the search box, you will see that you do NOT need any 3rd party backup software to make backup from SQL Server! |
|
|
|
|
Veritas Backup and SQL MP