Viewing 15 posts - 796 through 810 (of 1,790 total)
Does your system time match current time? If so, run something that will write an event to the SQL Server log like a DBCC CHECKDB (model) and see if you...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 9, 2009 at 7:03 am
matt.ma (2/8/2009)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 9, 2009 at 3:46 am
Yes. Check out this link to make sure you have everything covered.
Could you also consider log-shipping for this as well? A bit less complicated of a configuration.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 9, 2009 at 3:41 am
Sounds painful. Any reason you couldn't do log shipping? Curious.
I can't think of any side effects but I can't believe it would go smoothly all the time. Dropping replication...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 8, 2009 at 9:03 pm
You can stop the jobs thereby pausing replication. There are some caveats to this so the script gets a bit tricky. If you send me a private message (check my...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 8, 2009 at 8:54 pm
Yes, we run AV software on our SQL boxes. I was dead set against this for the longest time but most of the AV software folks have become intelligent about...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 7, 2009 at 4:23 pm
Two quick ways:
1. Use Excel query and save the spreadsheet with the query contained in it (along with the data source). Have it refresh on open. Lots of help...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 7, 2009 at 4:19 pm
Kind of hard to tell. Did the backup job fail due to lack of space? Ultimately the backup will occur first then the old file will be deleted - or...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 6, 2009 at 9:50 pm
What version of SQL Server, what service pack?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 6, 2009 at 9:36 pm
If you are using 2005 SP1 and you are using the maintenance plans to delete your files then you may be running into a known issue that was fixed in...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 6, 2009 at 9:32 pm
Nice, clearly I wasn't thinking!!! Thanks!
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 6, 2009 at 9:19 pm
Nice Lowell! I review the default trace a good bit and I'm sure this will be useful!
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 6, 2009 at 9:17 pm
Can you post details of what you were doing and when you got the error. You should be able to post a screenshot of the error in your reply as...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 6, 2009 at 9:14 pm
Triggers work off of DML actions being performed against the table, i.e. insert, update, delete. They don't fire off randomly or on a schedule.
It sounds like you need to...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 6, 2009 at 9:11 pm
Just to help but I believe the articles that GSquared was referring to was this[/url] and this[/url].
Please correct me if I am wrong.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 6, 2009 at 11:44 am
Viewing 15 posts - 796 through 810 (of 1,790 total)