Viewing 14 posts - 1 through 14 (of 14 total)
Thanks for the corrections Gila. I appreciate your help on this.
April 1, 2015 at 9:19 am
GilaMonster (3/30/2015)
Cpt_Picard (3/30/2015)
The OS can only read one data file per core.
This is not true. Any thread on any core can issue an IO request to any file. Please DO...
April 1, 2015 at 9:14 am
You may also want to review here for the data files unless you have 31 cores on your VM: http://www.sqlservercentral.com/Forums/Topic458542-148-1.aspx
The OS can only read one data file per...
March 30, 2015 at 4:16 pm
Assuming you're not moving system databases (master, msdb, or model)...
Is the SQL Server patched? If so, can you
1) Install and patch SQL Server on the VM then take a snapshot...
March 30, 2015 at 4:00 pm
After a long afternoon we were able to track this issue down to what appears to be an exchange configuration issue. I'm not an exchange expert in the least so...
December 10, 2013 at 9:47 am
Elliott Whitlow (12/9/2013)First thought is the delimiter between addresses, I *think* it needs to be comma and not semi-colon..
CEWII
Thanks for your reply!
I tried that but got the error below 🙁
One...
December 9, 2013 at 10:44 am
Also, here's the text from the RSReportServer.config file located at "C:\Program Files\Microsoft SQL Server\MSRS11.NamedInstanceName\Reporting Services\ReportServer" for the RSEmailDPConfiguration tag:
<RSEmailDPConfiguration>
<SMTPServer>RemoteSMTPAddress</SMTPServer>
<SMTPServerPort>
</SMTPServerPort>
<SMTPAccountName>
</SMTPAccountName>
<SMTPConnectionTimeout>
</SMTPConnectionTimeout>
<SMTPServerPickupDirectory>
</SMTPServerPickupDirectory>
<SMTPUseSSL>
</SMTPUseSSL>
<SendUsing>2</SendUsing>
<SMTPAuthenticate>
</SMTPAuthenticate>
<From>JWSReports@zachrycorp.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats>
</PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
<RenderingExtension>RGDI</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName>
</DefaultHostName>
<PermittedHosts>
</PermittedHosts>
</RSEmailDPConfiguration>
December 9, 2013 at 10:31 am
Thanks for your reply!
All the email accounts are to individuals and not distro list(s).
The To box contains: username@example.com;user.name@example.com
I am also asking my exchange admin to check things...
December 9, 2013 at 10:26 am
We recently began the SAP w/ SQL Server implementation and from what I've come across this may help you: http://scn.sap.com/docs/DOC-1006. Go pages 2 & 3 "SAP-Microsoft Alliance".
To view it...
April 11, 2013 at 4:21 pm
There is a COPY_ONLY full backup option with later versions of SQL Server. It does not affect the backup chain.
EDIT: and you can restore from a copy only.
August 3, 2012 at 12:12 pm
Here's the setup for my largest app, entire instance setup and it's a high priority app.
1 prod
1 QA
1 dev
1 SAN snap
2 FULL b/u .bak files (not compressed)
12 Diff b/u .bak...
August 3, 2012 at 10:38 am
I've never looked for one on this site before, however searching book review seems to return a few articles / blogs. Possibly searching by the title of one would be...
August 2, 2012 at 9:08 am
Mile Higher, at this point, I think would be best to take SpringTown's advise and download from the site linked by opc.three.
I would advise the same steps in deploying...
August 2, 2012 at 7:28 am
There is a script here http://www.sqlservercentral.com/scripts/Administration/73478/ posted by Pavle-192195 that should do everything you need with the proper parameters. It also does an actual restore to a test DB and...
August 1, 2012 at 2:01 pm
Viewing 14 posts - 1 through 14 (of 14 total)