Viewing 15 posts - 751 through 765 (of 1,583 total)
Of course, I agree. Just saying as a general rule...more of a when in doubt - For Full Recovery DB's I run log backups every 15 minutes so generally...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 14, 2013 at 10:46 am
midnight251 (2/14/2013)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 14, 2013 at 10:31 am
UconnDBA (2/12/2013)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 12, 2013 at 1:13 pm
There's really nothing involved if you've not customized the config files, just re-install the reporting server - just remember this will delete everything in your RS databases and you will...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 12, 2013 at 11:05 am
In the Start menu, Under Program Files, go to Configuration Tools, then choose "Reporting Services Configuration Manager", you will find out if you are using encryption keys there.
If you don't...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 12, 2013 at 11:01 am
If you don't have any backups to restore you should uninstall and re-install Reporting Services. If you have set any encryption keys or custom changes made to your...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 12, 2013 at 9:55 am
This is not to mention that having an Agent job run a job every 5 seconds would be a foolish thing to do when considering other aspects of the system....
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 12, 2013 at 6:15 am
Are you using a custom script or are you using a Maintenance Plan? Could be perhaps some of the backups are going to the default backup folder "<<Installation Path>>"\MSSQL10.MSSQLSERVER\MSSQL\DATA"...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 12, 2013 at 6:11 am
Sorry I have to disagree...I believe it would work perfectly.
If the OP created a job that ran the package I'm describing say every 5 seconds, the package does a check...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 11, 2013 at 9:28 pm
At the package level create a package-level variable, set it to data type = String
Create a connection manager for the file (only really needed for the initial set up, as...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 11, 2013 at 8:59 pm
Check out this article, I think it will help 🙂
http://www.sqlservercentral.com/Forums/Topic1388718-391-1.aspx#bm1388866
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 11, 2013 at 8:22 pm
Have you tried initializing it from a full backup? Naturally you would have to change the setting in your publications for "Allow initialization from backup files" to True...and you...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 11, 2013 at 8:19 pm
opc.three (2/11/2013)
You could also do this a few...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 11, 2013 at 8:11 pm
Regardless, there's little good reason to have that as part of a maintenance plan. If the maint plan rebuilds indexes or updates stats, it'll invalidate the plans that depend on...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 11, 2013 at 8:00 pm
+1 for Idera SQL Diagnostic Manager. I use it and have tried Red Gate's tool as well but preferred Idera because it had a nicer "look and feel"...decent built...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 11, 2013 at 12:12 pm
Viewing 15 posts - 751 through 765 (of 1,583 total)