Viewing 15 posts - 976 through 990 (of 2,897 total)
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
From the article: " ... The DUMP statement is included for backward compatibility ..."
You are misinterpreting "backward compatibility "
It means that old syntax (from SQL 6, 7, 2000 etc...) can...
March 18, 2011 at 7:14 am
When using replication, I often found it useful to set up a test publisher & subscriber database to try out different things before going to production.
March 17, 2011 at 10:02 am
gissah (3/16/2011)
Thank you miltman that works.I guess I have to create a parameter to select
the company name.
Thanks a lot
I don't see how a parameter will help you.
You need to take...
March 17, 2011 at 9:14 am
Viewing 15 posts - 976 through 990 (of 2,897 total)