Forum Replies Created

Viewing 15 posts - 316 through 330 (of 430 total)

  • RE: Linked Server weirdness to Sybase

    It has been a long time since i worked in a mixed environments and my current one does not a sybase db so I can only mention few things which...

    July 27, 2011 at 1:09 am

    #1358976

  • RE: new sql agent job

    Even I am not aware about changing the default setting here. Probably, while creating a new job, you can uncheck the option. however, I always like to see SQL Server...

    July 27, 2011 at 12:55 am

    #1358973

  • RE: msdb database

    PhilipC (7/26/2011)

    On the msdb database, I've always just left the Autogrowth to "By 10 percent, unrestricted growth" and not really managed it in the same way as I would a...

    July 27, 2011 at 12:52 am

    #1358971

  • RE: backup retention period

    forsqlserver (7/26/2011)

    If I set up the backup retention period of 10 days.Does it mean that no body can delete that backup file for 10 days except administrator,or Pls clear my...

    July 27, 2011 at 12:46 am

    #1358970

  • RE: a new db is created

    Using default trace can give you answers but if your server has some heavy activity going, the default traces will be wiped out soon. Also, I am not sure but...

    July 27, 2011 at 12:41 am

    #1358967

  • RE: I am configuring the backup of all the databases using Maintenance Plans.

    TheSQLGuru (7/26/2011)

    Stop using maintenance plans. They have lots of issues, especially when it comes to indexes/statistics mx. Get the awesome, free and fully documented stuff from ola.hallengren.com

    I agree...

    July 26, 2011 at 12:04 pm

    #1358716

  • RE: I am configuring the backup of all the databases using Maintenance Plans.

    forsqlserver (7/25/2011)

    Yes I have test database for mirroring and test2,test3 database fro logshipping.Now I am applying ir for single database still MNITENANCE CLEANUP TASK is not deleting bak file.

    OK. so...

    July 25, 2011 at 3:38 am

    #1357657

  • RE: I am configuring the backup of all the databases using Maintenance Plans.

    forsqlserver (7/25/2011)

    The output of the file:

    Microsoft (R) SQL Server Execute Package Utility

    Version 10.50.1600.1 for 32-bit

    Copyright (C) Microsoft Corporation 2010. All rights reserved.

    Started: 12:41:00 PM

    Error: 2011-07-25 12:41:18.38

    Code:...

    July 25, 2011 at 1:54 am

    #1357631

  • RE: I am configuring the backup of all the databases using Maintenance Plans.

    forsqlserver (7/25/2011)

    My job is failing,it is a created on Maintenance Plan in which one is backup of all databases and other is Maintenane cleanup task to delete the older files...

    July 25, 2011 at 12:34 am

    #1357623

  • RE: Rollback of a Transaction

    GilaMonster (7/21/2011)

    chandan_jha18 (7/21/2011)

    GilaMonster (7/21/2011)

    If the server crashes, all open transactions are rolled back on restart. It's called crash recovery.

    I meant to say that my workstation or management studio crashed. In...

    July 21, 2011 at 1:00 pm

    #1356682

  • RE: Rollback of a Transaction

    Roy Ernest (7/21/2011)

    DBCC Opentran will show the open transactions and using the SPID you can use

    DBCC Inputbuffer (SPID Number)

    Or you can use

    select s.spid , [Text] as Code from sys.sysprocesses...

    July 21, 2011 at 12:53 pm

    #1356675

  • RE: Rollback of a Transaction

    GilaMonster (7/21/2011)

    If the server crashes, all open transactions are rolled back on restart. It's called crash recovery.

    I meant to say that my workstation or management studio crashed. In that case,...

    July 21, 2011 at 12:38 pm

    #1356666

  • RE: DBCC CHECKALLOC errors : Msg 2576, Level 16, State 1

    GilaMonster (7/14/2011)

    Fixing that error requires Allow_data_loss because of the types of repairs. If those are the only errors, then it can fix without actually discarding anything

    thank you Gail. while running...

    July 14, 2011 at 5:58 am

    #1352724

  • RE: DBCC CHECKALLOC errors : Msg 2576, Level 16, State 1

    GilaMonster (7/14/2011)

    chandan_jha18 (7/14/2011)

    repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (DB).

    There's your answer right there.

    I tried that and now i found that in both the...

    July 14, 2011 at 5:36 am

    #1352704

  • RE: DBCC CHECKALLOC errors : Msg 2576, Level 16, State 1

    there was another amazing thing I discovered here.Just for my fun sake, i created a maintenance plan to rebuild all the indexes and rather than using the wizard to do...

    July 14, 2011 at 4:54 am

    #1352687

Viewing 15 posts - 316 through 330 (of 430 total)