Viewing 15 posts - 16 through 30 (of 318 total)
I hate to post other sites on here, but the following is most likely the why and how of what you are running into.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
May 9, 2013 at 7:43 am
Paul Randal may explain it better than anyone else
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
March 6, 2013 at 1:43 pm
In the off chance the firewall is not completely off, you should add port 1433 to the Windows Firewall.
Have you verified that both SQL Servers "Allow remote connections to this...
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
March 6, 2013 at 1:30 pm
I would agree with foxxo, in that a reinstall would be the most simple solution.
However, if you are up for a taking a risk, I recall the location of the...
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
March 6, 2013 at 1:16 pm
Have you looked at the Job History in the Activity Monitor? This should show how long each step (you stated your job had multiple steps) is taking as compared...
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
March 6, 2013 at 1:07 pm
Activity Monitor can be found in the Object Explorer under the Management folder.
You can close all the connections prior to your restore, but more than likely SQL Agent is reconnecting...
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
February 26, 2013 at 8:49 am
Is the backup part of a Maintenance Plan in which you have more than one database being backed up in it? Are all of the databases within the Maintenance...
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
December 17, 2012 at 7:41 am
Are you attempting to upgrade to SQL Server Enterprise Edition 64-bit?
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
December 6, 2012 at 10:17 am
Are you able to see the Maintenance Plan if you connect to the server from another instance?
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
November 29, 2012 at 7:11 am
Do you have a backup of the msdb database to restore to?
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
November 13, 2012 at 7:41 am
Gail - what if it were a system database, in particular the master database?
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
October 26, 2012 at 8:08 am
Jr. DBA
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
October 18, 2012 at 7:17 am
One thing to watch for with Maintenance Plans is when you have a particular plan being utilized across many databases and you add or drop one of those databases, the...
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
October 16, 2012 at 7:24 am
We use a tool called Apex SQL Diff. It was once reviewed by this very site.
http://www.apexsql.com/sql_tools_diff.aspx
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
August 23, 2012 at 9:19 am
XP_CMDSHELL allows you to run OS commands via T-SQL
What you wanted to do was either
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO
OR since you are familiar with the Surface...
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
November 30, 2011 at 3:35 pm
Viewing 15 posts - 16 through 30 (of 318 total)