Viewing 15 posts - 6,166 through 6,180 (of 9,715 total)
The Spartans (3/29/2011)
i have created the Log Shipping in my system.it taking backups of transaction logs and working fine and in the secondary server the backups are not moving and...
March 29, 2011 at 7:56 am
CirquedeSQLeil (3/28/2011)
GilaMonster (3/28/2011)
Not trying to start any bashing or pile-ons, but this has to rate high on the list of most useless replies: http://www.sqlservercentral.com/Forums/FindPost1084783.aspx
This is a nice example of a...
March 28, 2011 at 9:34 am
I recommend adding logging to the SQL Job.
Edit Step 1 and highlight Advanced on the left. It'll change from the code screen to the advanced screen.
In the Output File box,...
March 28, 2011 at 9:15 am
Gail gave you all the code you need. Now you have to create a job with a T-SQL task. Do you have any other DBAs on the team that can...
March 28, 2011 at 8:10 am
GilaMonster (3/28/2011)
Set up a SQL Agent job scheduled to run at midnight. The job step needs a single line of T-SQL
DBCC CHECKIDENT (CALLS, RESEED, 0)
Needless to say,...
March 28, 2011 at 7:53 am
Here's an article link on how you can post your code (and questions) so we have enough information to assist you.
http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D
Your question doesn't sound very complex, but it would help...
March 28, 2011 at 6:04 am
I hate to say it, but this might be a case of "Call Microsoft." I certainly can't think of why your connection would fail out of the blue if nothing...
March 28, 2011 at 5:12 am
[Jim].[dba].[Murphy] (3/27/2011)
March 28, 2011 at 5:09 am
Sachin Nandanwar (3/28/2011)
March 28, 2011 at 4:53 am
DOH. I knew there was a reason I asked this question and I got so caught up in getting my DDL together that I forgot the most important part.
Rephrase: Not...
March 25, 2011 at 12:50 pm
Checking for triggers or logon scripts is a good idea. Also, check the application code to see if it has a way of altering the SA password or the SA...
March 25, 2011 at 12:20 pm
GSquared (3/25/2011)
Sounds like the sa password got changed.
Maybe, but I don't think restarting the server would have resolved a changed password issue.
I do agree that SA should not be used...
March 25, 2011 at 12:01 pm
deba_20032004 (3/25/2011)
So there is no way to improve performance.
Unless I'm misreading your comment, it sounds like you've already made up your mind that we can't help you.
Take a deep breath....
March 25, 2011 at 11:58 am
We have an active / active / active / passive setup. So, yes, definitely possible. Use virtual names when possible so when your servers reach EOL, you're not changing a...
March 25, 2011 at 11:53 am
Viewing 15 posts - 6,166 through 6,180 (of 9,715 total)