Viewing 15 posts - 2,491 through 2,505 (of 7,502 total)
Of course using a witness, like WayneS proposed, is the more natural and preferred way.
The one thing overlooked many times, is the fact of how many databases you plan to...
January 7, 2011 at 12:35 am
What's the size of the databases you are trying to copy ?
If that size is small, maybe a simple backup / restore operation can serve you well in stead of...
January 7, 2011 at 12:11 am
we have no alerts configured in sqlserver for this, but our windows eventlog monitoring tool captures it and raises alerts in HPOpenview.
It is an easy way to use alerts to...
January 6, 2011 at 2:51 am
I polled for the third option 😛
I have a facebook account.
Just to get a glimps of the technology and how it serves some people.
I mostly get to see messages...
January 6, 2011 at 1:50 am
Thank you for you comment.
I need to add 2 comments to the article:
1) You need to setup queue monitoring !
If things fail, your server...
January 6, 2011 at 12:19 am
Cannot test on SQL2005 profiler right now, but on SQL2008R2 the saved template contains the expected events and columns
January 5, 2011 at 12:03 pm
For that matters, you can just open the trace file with profiler and use the save trace as script feature.
I thought you were looking for a solution to actually modify...
January 5, 2011 at 10:28 am
I must admit I haven't heart of such a setting to controle the file size for the default trace, nor did I search for it in sqlserver.
The easiest way IMO...
January 5, 2011 at 9:35 am
No I didn't write an article on it.
Adam Hanes published a nice artilce at SSC: "Default trace - a beginner's guide" http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/ with a nice follow up discussion.
Another, more easy...
January 5, 2011 at 1:37 am
also check out the restore process in the trace.
If you restore a backup of a db in single user mode, it will be in single user mode when the restore...
January 4, 2011 at 2:54 pm
to import and process the default trace files have a look at
http://sqlblog.com/blogs/tibor_karaszi/archive/2008/06/19/did-we-have-recent-autogrow.aspx
It is a good starting point to figure out when things happen !
Then start a regular trace right...
January 4, 2011 at 2:49 pm
ALZDBA (12/21/2010)
WayneS (12/21/2010)
ALZDBA (12/20/2010)
- New project on a new folder generates "creating project failed"
- opening an existing...
January 4, 2011 at 2:46 am
AFAIK you cannot rename a named instance.
Best is to just install an instance with the new name and port everything from your wrongly named instance to the new one.
After that...
January 4, 2011 at 1:05 am
Craig Farrell (1/3/2011)
For anyone following the earlier infringment discussion, some sleuthing around SSC finally revealed the blog owner. A brief PM conversation seems to have dealed with that issue.
Good...
January 3, 2011 at 3:18 pm
Please read my little article called "Scope: The drastic caveat with Logon Triggers. " at http://www.sqlservercentral.com/articles/Administration/64974/
Main message: If you don't need to interrupt the connection at connect time, don't do...
January 3, 2011 at 3:12 pm
Viewing 15 posts - 2,491 through 2,505 (of 7,502 total)