Viewing 15 posts - 1,006 through 1,020 (of 2,897 total)
I don't know the problem, but looks like it would be a good idea to take fresh full backup now.
March 3, 2011 at 7:37 am
Indianrock (3/1/2011)
March 1, 2011 at 1:28 pm
DBA328 (2/25/2011)
Could you try to add the SQL Server servcie account to local administrator group and try again. I susepct it is permission issue.
I was going to try that next,...
February 25, 2011 at 11:44 am
Tell your manager that shrinking it is like crumpling up a piece of paper because you don't need it right now, then flattening it out (growth) when you do need...
February 24, 2011 at 1:43 pm
If you don't purge your full backup history, you can use that to get growth over time. It will show backup size, not dabase size, but the growth percentage should...
February 24, 2011 at 12:37 pm
And on yet another server, MSSQLSERVER will start with the new account, but SQLSERVERAGENT will not ... ?!?! How can changing an account go wrong in so many...
February 24, 2011 at 10:33 am
The optional free Performance Dashboard reports can be installed to give you that type of information.
Also, 3rd party tools like Idera's Diagnostic Manager, among others.
February 24, 2011 at 6:20 am
I had a developer come storming in one day, demanding to know who dropped his tables that were there last week. It so happened I had a server side...
February 23, 2011 at 4:01 pm
I assume you're adding the user back manually every day ? Take that script and put it into a new job, then schedule to run at the appropriate time...
February 22, 2011 at 10:51 am
Is one of your tables actually also a view, and the server name is hardcoded in there ?
February 22, 2011 at 10:48 am
Or you could just leave it at 10 Gig since it may need to grow again anyway.
Note the warnings and conditions, such as "...no activity occur in the tempdb database...
February 22, 2011 at 7:34 am
Nils, Sorry for the confusion and thanks for all your help ... see my corrected & edited post above.
February 21, 2011 at 12:58 pm
Thanks for the help ... (Big Edit because I think I found the problem... didn't realize there was already a reply)
Here's a follow-up for anyone else with a similar problem
...
February 21, 2011 at 12:18 pm
Luk (2/21/2011)
homebrew01 (2/21/2011)
Doesn't this mean you might get varied results if more than one b.datefield qualifies as > than a.datefield ?
Why not use the JOIN syntax...
February 21, 2011 at 11:58 am
Viewing 15 posts - 1,006 through 1,020 (of 2,897 total)