Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)

  • RE: Installing SP1 on Cluster

    To apply Service Pack 1 on SQL Server 2008(Outage will be minimal):

    1)Failover Group DBQA to DBSQ02 Node

    2)Apply SP1 on DBSQ01 Server(Including Database Engine and Analysis Service)(Passive Node)

    3)Reboot the DBSQ01 Server

    4)Failover...

  • RE: SQL MAINTENANCE PLAN FAILING

    only solution is wait for next days the job will run successfully.if not then still wait of one days more.

  • RE: SQL MAINTENANCE PLAN FAILING

    thanks

    But five days maintenance plan properly working but last 2 days is failing but the backup which includes in the maintenance plan is working but the removing of old files...

  • RE: Maintenance plan will not run as scheduled

    4. Open the registry editor by going to Start > Run > regedit.

    5. Browse to the "SQLServerAgent" section. The path is something like

    "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL

    Server\MSSQL.1\SQLServerAgent".

    6. Modify the following...

  • RE: Maintenance plan will not run as scheduled

    you have to set two value in regisry.

    in run type regedit

    then microsoft sql server folder there is sqlserver agent folder

    in that two value you have to send

    1)usedatabasevalue to 1

    2)databasemailprofile...

Viewing 5 posts - 1 through 5 (of 5 total)