Viewing 15 posts - 976 through 990 (of 2,900 total)
If a database is in FULL recovery, and you are taking t-log backups, there's not really a good reason to only take them every hour, or 3 hours. Just change...
March 30, 2011 at 10:56 am
steveb. (3/29/2011)
setup regular t-log backups.
There's your answer .... Every 15-20 minutes for us.
March 30, 2011 at 9:20 am
Side comment ... Why aren't you on SP3 ?
Any time someone is on an old version, it raises the question of if their problem would be fixed by being on...
March 29, 2011 at 3:12 pm
Why the 6 hour restriction ? Maybe the backups will not have a big impact on users. Schedule the high priority backups at the beginning, and maybe it's ok...
March 29, 2011 at 3:07 pm
Are there 2000 records in the table, or is 2000 the number returned based on a 'where' clause or join to another table.
March 23, 2011 at 12:27 pm
Maybe connectivity across the network dropped ?
You could try copying the file to the local server, then run the restore locally.
March 23, 2011 at 12:21 pm
I think you will need a cleanup step for each individual extension. And don't include the "dot" ..... use TRN, not .TRN
Also, be sure you are on at...
March 22, 2011 at 8:32 am
GilaMonster (3/18/2011)
homebrew01 (3/18/2011)
In my scenario, you would need a t-log backup sometime after 3 pm, and before the next full backup.
Assuming all the backups are intact and restorable, why...
March 18, 2011 at 11:10 am
You said you're only doing a t-log backup once a day. In my scenario, you would need a t-log backup sometime after 3 pm, and before the next full backup....
March 18, 2011 at 10:46 am
Ninja's_RGR'us (3/18/2011)
No he's actually really smart, and he never had problems with "his" stuff. Hence my "what if" has very little weight.
What If:
Monday 1 am Full Backup
Monday 10...
March 18, 2011 at 10:34 am
If you're consulting, and there's a disaster, maybe you'll get more billable hours to help fix it. 😀
Maybe someone in the business end needs to know they have 23...
March 18, 2011 at 9:45 am
What is the reason for not taking frequent t-log backups ? I can't think of any bad reasons, let alone good reasons.
March 18, 2011 at 9:22 am
"...I'm wondering is my tlog backup is actually usable to restore to any point in time during the day. ..."
Only up to the point of your most recent t-log backup....
March 18, 2011 at 9:03 am
A while back I did a restore from BackupExec, then applied transaction logs without a problem. I assume your BackupExec is a Normal "BACKUP DATABASE", and not a file backup...
March 18, 2011 at 8:59 am
Maybe you could make a 2000 Maint Plan just to delete the old files, and keep your 2005 plan for the backups.
March 18, 2011 at 7:28 am
Viewing 15 posts - 976 through 990 (of 2,900 total)