Viewing 15 posts - 16 through 30 (of 317 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.
May 9, 2013 at 7:43 am
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...
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...
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...
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...
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...
December 17, 2012 at 7:41 am
Are you attempting to upgrade to SQL Server Enterprise Edition 64-bit?
December 6, 2012 at 10:17 am
Are you able to see the Maintenance Plan if you connect to the server from another instance?
November 29, 2012 at 7:11 am
Do you have a backup of the msdb database to restore to?
November 13, 2012 at 7:41 am
Gail - what if it were a system database, in particular the master database?
October 26, 2012 at 8:08 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...
October 16, 2012 at 7:24 am
We use a tool called Apex SQL Diff. It was once reviewed by this very site.
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...
November 30, 2011 at 3:35 pm
Viewing 15 posts - 16 through 30 (of 317 total)