Viewing 15 posts - 406 through 420 (of 972 total)
Enable backup compression. Try to use something like robocopy to move the file, it will keep trying if a "hiccup" happens down the pipe.
February 23, 2011 at 1:20 pm
Can you provide the lines prior to this message? Before that message is printed out it should have some other lines above it with information.
Something like this:
Insufficient memory available..
Error: xxxxx,...
February 23, 2011 at 7:12 am
Overall there should be no reason to move them unless you just want to. As long as you are doing full backups of the system databases on a regular basis...
February 22, 2011 at 12:26 pm
gemisigo (2/21/2011)
By the way, why does this "allow update" setting make maintenance plans fail in the first place?
What version of SQL are you running? According to BOL: allow updates Option....
February 22, 2011 at 12:11 pm
VBScript to call WMI objects would be your only other option. I know you can get scripts with Google search to check status and certain properties. I have done this...
February 21, 2011 at 6:36 pm
I would suggest PowerShell if you have it running on your servers (prior to Window Server 2008). Look at the Get-Service cmdlet.
February 20, 2011 at 6:46 pm
Preference over GUI or using commands: There are some task that using the GUI is just more effecient, with the exception of needing to do something across multiple instances/servers. You...
February 20, 2011 at 6:42 pm
Why would they do it for the Ask.SQLServerCentral.com site then? Do they not get revenue from that site?
February 17, 2011 at 3:42 pm
Posted in wrong forum/topic...might want to repost or request moderator to move it.
February 17, 2011 at 2:47 pm
Tara-1044200 (2/17/2011)
do you think ApexSQL or SQL Complaince managerv3.2 will give those options for me?
Just from brief read Apex SQL Log looks like it is could be what you are...
February 17, 2011 at 2:24 pm
Jack Corbett also has a video/slide deck from doing SQLLunch on hitting the default trace for information. The slide deck are linked hereon his blog. You can go to the...
February 17, 2011 at 9:37 am
Default trace - A Beginner's Guide[/url]
The above SSC article should get you familiar with the script used. The Event ID you want to look for is 108. You can see...
February 17, 2011 at 9:33 am
Tara-1044200 (2/17/2011)
what is the best tool in the market that can be used to monitor all acitvites of sql server like who changed what permissions and when.
I would say SQL...
February 17, 2011 at 9:16 am
Duncan Pryde (2/17/2011)
February 17, 2011 at 7:18 am
Duncan Pryde (2/17/2011)
Essentially the Bulk Logged recovery model is the same as the Full recovery model except that some operations are minimally logged. As long as none of those operations...
February 17, 2011 at 5:45 am
Viewing 15 posts - 406 through 420 (of 972 total)