Forum Replies Created

Viewing 15 posts - 331 through 345 (of 782 total)

  • RE: No maint plans

    @ David..

    Can it be that i have sql 2005 sp4 installed on my local machine..tht is preventing me to do tht stuff?

    What i am doing is that :- I open...

    February 25, 2011 at 1:04 pm

    #1291737

  • RE: No maint plans

    David Benoit (2/25/2011)

    Is is possible that sa is not actually a part of the sysadmin server role? Can you check?

    On the server level, sa has sysadmin checked..

    Regards,

    Sushant

    February 25, 2011 at 11:58 am

    #1291716

  • RE: No maint plans

    David Benoit (2/25/2011)

    Yes, maintenance plans were available in 2000. My guess is that you are lacking permissions to see / create those at this point.

    I cant see it maybe...

    February 25, 2011 at 11:06 am

    #1291674

  • RE: Tempdb not shrinking

    Carlton Leach (2/25/2011)

    Tell your manager that you've checked with all of us and: it's not possible to shrink tempDB 😀

    Carlton.

    It seems as if its the only alternative left ...:)

    Regards,

    Sushant

    February 25, 2011 at 7:02 am

    #1291507

  • RE: Tempdb not shrinking

    .

    February 25, 2011 at 6:56 am

    #1291503

  • RE: Tempdb not shrinking

    homebrew01 (2/24/2011)

    Tell your manager that shrinking it is like crumpling up a piece of paper because you don't need it right now, then flattening it out (growth) when you do...

    February 24, 2011 at 2:11 pm

    #1291283

  • RE: Strange !!!

    No, its not a sharepoint database.

    Regards,

    Sushant

    February 24, 2011 at 1:17 pm

    #1291255

  • RE: Strange !!!

    Lowell (2/24/2011)

    it depends on the collation of the database you are connecting to.

    if you create a database with a case sensitive collation, all the tables and objects are going to...

    February 24, 2011 at 12:54 pm

    #1291239

  • RE: Temp DB

    subha.mcts2005 (2/22/2011)

    Hi,

    one of my production server Tempdb Mdf file has increased 2GB with in 2 Hours on today morning.

    why it was happened? what are the causes for this?

    please...

    February 24, 2011 at 12:24 pm

    #1291207

  • RE: Tempdb not shrinking

    grahamc (2/24/2011)

    It is generally very difficult to SHRINK the TEMPDB as its almost constantly in use. If you really must bring down the size of the TEMPDB, reduce the initial...

    February 24, 2011 at 7:16 am

    #1290964

  • RE: Tempdb not shrinking

    TheSQLGuru (2/24/2011)

    SKYBVI (2/24/2011)

    I also dont like shrinking the tempdb personally.

    10gb is fine for a 340 gb prod db, i know that.

    But my manager doesn't like that.

    I told her many reasons...

    February 24, 2011 at 7:00 am

    #1290946

  • RE: Tempdb not shrinking

    SKYBVI (2/23/2011)

    DBCC FREEPROCCACHE

    GO

    USE [tempdb]

    GO

    DBCC SHRINKDATABASE(N'tempdb', 10, TRUNCATEONLY)

    USE [tempdb]

    GO

    sp_updatestats;

    I will be running it at night.

    Regards,

    Sushant

    I tried this also, the job runs fine without any error, but the size of tempdb remains...

    February 24, 2011 at 6:53 am

    #1290940

  • RE: Tempdb not shrinking

    I also dont like shrinking the tempdb personally.

    10gb is fine for a 340 gb prod db, i know that.

    But my manager doesn't like that.

    I told her many reasons for not...

    February 24, 2011 at 6:47 am

    #1290930

  • RE: Backup time

    @ steven

    Thanks a lot.

    Regards,

    Sushant

    February 24, 2011 at 6:32 am

    #1290923

  • RE: Refactoring

    very tough question

    February 24, 2011 at 6:02 am

    #1290904

Viewing 15 posts - 331 through 345 (of 782 total)