Viewing 15 posts - 31 through 45 (of 53 total)
This may be what you need. http://msdn.microsoft.com/en-us/library/ms143694.aspx.
It states that "SQL Server supports multiple instances of the Database Engine, Analysis Services, and Reporting Services on the same computer. You...
April 9, 2013 at 11:55 am
Oh. Ok. This should work for you. Works for me. Let me know.
April 9, 2013 at 11:50 am
First, I have a question. Why arent you using SQL Server Compression when backing up? This generally reduces the backup file size down to less than 20% of...
April 9, 2013 at 8:28 am
Will work if you have your dates with another colon, like '2013-03-11 00:00:00.00'.
John
March 12, 2013 at 12:54 pm
If creating the reporting databases is the only issue, shouldn't have to reinstall SSRS. Just bring up the Reporting Configuration Manager and on the Database tab click "Change Database"....
February 12, 2013 at 12:37 pm
Probably a timing issue. Its not seeing the previous days backup as actually older than 1 day yet. To get around this can set maint plan to delete...
January 29, 2013 at 6:29 am
Shrinking is the way to reclaim space. When its said "not to shrink", I think means not to shrink automatically without thinking about it. If you shrink and...
July 25, 2012 at 12:14 pm
If this is a production environment all changes should go thru the DBA. The DBA is the one that will get the call when the job fails.
July 25, 2012 at 12:06 pm
...also check the firewall to be sure TCP/IP port used by named instance is allowed through inbound firewall.
July 18, 2012 at 12:39 pm
Unless there is absolutely another reason to do otherwise, which i have to this point i have yet to find in the 10+ years have been doing SQL...
...
June 26, 2012 at 8:52 am
In every instance I create a maintenance plan that backs up ALL databases. This includes system and user databases. This way if/when user databases are created they will...
June 21, 2012 at 12:10 pm
Be sure you are cleaning off backups regularly. Our backup jobs delete anything older than 7 days, after they have been copied to a server that retains all our...
June 21, 2012 at 11:41 am
I would first check if you have enough available freespace on installation drive (usually c:). Also check to see if you have an open dialog box behind installation screen...
June 21, 2012 at 10:04 am
Just a spinning wheel. With new solutions, new problems. We are just finding ways to keep ourselves busy, so we can ignore who we really are (spirit) and...
June 15, 2012 at 7:32 am
Can use this to make seperate fileds...
select substring(name,1, len(name)-(charindex('\',reverse(name))))
,substring(name,len(name)-(charindex('\',reverse(name)))+2,len(name))
...
June 13, 2012 at 11:50 am
Viewing 15 posts - 31 through 45 (of 53 total)