Viewing 15 posts - 8,311 through 8,325 (of 9,720 total)
And don't forget to check the size of Model too. TempDB is created off the settings on Model (all databases are) and if Model was changed, than all dbs will...
June 8, 2009 at 4:31 am
Hee.
Thanks, Steve. I appreciate the support.
June 4, 2009 at 4:11 am
Brad,
I too am a fictional writer, so I understand the pains you're going through. However, most people who publish code solutions on the internet usually do so with the expectation...
June 3, 2009 at 3:32 pm
????
SQL Server shouldn't require SSIS in order to use database mail. SSIS SMTP mail should be completely separate from the database engine SMTP mail.
You should report this to Microsoft. Those...
May 22, 2009 at 4:41 am
Tim Mitchell (5/20/2009)
Must be finals week :w00t:
I didn't even think about that. You're probably right. @=)
May 21, 2009 at 5:02 am
jabba (5/20/2009)
Still an issue they end up in the msdb.dbo.sysmail_sentitems
That tells me the issue is with the mail server, not SQL.
May 20, 2009 at 6:02 am
Ah. Okay. I think I'm getting it. But here's a sanitized version of the main summary (Fact) table:
Create MyTable (ReportType tinyint, BeginDate datetime, EndDate datetime, PayType varchar(20), BatchNumber int, PayeeID...
May 19, 2009 at 4:53 am
Taking FULL backups of your main server should not interupt the log shipping process. So long as you continue to restore the logs to the LS server *in order*. EDIT...
May 19, 2009 at 4:19 am
There's no good answer to that. It depends on your hardware, your server configuration, and how much parallell threading you allow the server to do.
If you absolutely need a number,...
May 18, 2009 at 8:32 am
SQL_Monster (5/18/2009)
The only thing i can do is backup and restore. But apart from that can't i restore or perform any backups on this db ?
Not quite sure what you...
May 18, 2009 at 7:48 am
Have you checked the mail server name? If the SMTP mail server isn't working, then SQL Server would queue the emails and not realize anything is wrong.
Also, it could be...
May 18, 2009 at 5:11 am
I'm not missing detail values so much as the details are even aggregated. I know that sounds odd, but that's the way it is. Say you have an order with...
May 18, 2009 at 5:07 am
I agree with Lynn. Unless you're experiencing serious space issues, leave it alone. I've had this problem several times myself and usually it's a valid process. Only on rare occasions...
May 18, 2009 at 5:01 am
By the By, your restore plan for the main server (assuming you use FULL, Differential & Transaction Log backups) will need to be as follows:
Restore the most recent FULL, restore...
May 18, 2009 at 4:55 am
Viewing 15 posts - 8,311 through 8,325 (of 9,720 total)