Forum Replies Created

Viewing 15 posts - 16 through 30 (of 318 total)

  • RE: Maintenance Plans - Modify does not work !?

    I hate to post other sites on here, but the following is most likely the why and how of what you are running into.

    http://paulgrevink.wordpress.com/2011/05/15/ms-sql-2008-r2-issue-impossible-to-modify-a-maintenance-plan/

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: TempDB optimization

    Paul Randal may explain it better than anyone else

    [/url]

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: Can't Connect to SQL Server 2005

    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.

  • RE: SQL Agent troubles - The system cannot find the file specified.

    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.

  • RE: sql server 2005 issues with nightly jobs

    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.

  • RE: Restore failed for Server. (Microsoft.SqlServer.Smo)

    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.

  • RE: Maintenance plan DB bAckup plan failing

    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.

  • RE: Upgrade from SQL Server 2005 Standard to Enterprise

    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.

  • RE: Maintenance PLans in SQL Server 2005

    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.

  • RE: MSDB database not responding

    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.

  • RE: SQL Server crashes when data drive full?

    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.

  • RE: Types of DBA's ???

    Jr. DBA

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: Unable to deallocate kept page - DBCC CHECKDB

    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.

  • RE: Database to Database migration tools?

    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.

  • RE: Modify Package Issue

    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.

Viewing 15 posts - 16 through 30 (of 318 total)