Viewing 15 posts - 26,491 through 26,505 (of 39,922 total)
Very strange. Copy only backup? Was this model by any chance?
Any other data in the logs?
November 10, 2008 at 12:07 pm
Diff backups run well and Mike has a great explanation.
Note that diffs grow larger each time because each diff grabs data since the last full, not since the last diff.
November 10, 2008 at 12:06 pm
The backup process throws pages out as quickly as it can. It has no tolerance for delays because of the nature of the backup. It is NOT anything like a...
November 10, 2008 at 12:05 pm
They all do about the same thing. Performance? They'll all be close. You might have some machines faster with one, not on others.
I work for Red Gate, but I've considered...
November 10, 2008 at 12:04 pm
They all do about the same thing. Performance? They'll all be close. You might have some machines faster with one, not on others.
I work for Red Gate, but I've considered...
November 10, 2008 at 12:04 pm
either something else was running or you had a conflict.
Are you backing up to new files all the time? Could have corrupted a file and that might stick the...
November 10, 2008 at 12:01 pm
you can set an alert on size, but I'm not sure you can pass that to a proc. You can probably get the size in T-SQL, but if you should...
November 10, 2008 at 11:49 am
It's got to be someone with owner level permissions. I didn't think DELETE allowed this.
I'd run a trace, looking for that table or for the TRUNCATE command.
November 10, 2008 at 11:47 am
Someone pointed it out; we don't know what the issues are. It's like us designing applications and users not realizing what the issues are until they see the final product....
November 10, 2008 at 8:05 am
I thought you had an interesting idea and it's worth considering for other people. I'm not sure how performance has changed. That would be an interesting follow-up.
Actually it would be...
November 10, 2008 at 7:45 am
You should be able to limit users from deleting entire tables. If you are restoring them, likely it's not part of their job.
You can download Log Rescue from Red Gate,...
November 9, 2008 at 11:24 am
How are you getting the new name? It it just the letter plus the row number? You need a tally type table to do this in 2000.
November 9, 2008 at 11:22 am
You can run fn_my_permissions once connected to see what permissions she has.
http://msdn.microsoft.com/en-us/library/ms176097.aspx
If you are getting the connection timeout, likely she is having network issues. Could be communications or firewall. How...
November 9, 2008 at 11:20 am
Be sure you know where and how to look for answers as well. You might get stumped, but it will help if you know how to find answers.
November 9, 2008 at 11:18 am
Viewing 15 posts - 26,491 through 26,505 (of 39,922 total)