Increasing Size of Database

  • I am new to Sql Server. Dear friends i need your support.

    I have two environments in Sql Server 2005. one is test and second is production.

    The size of production is 60GB and the size of test is 70GB.

    Production environment has 11 files with one .mdf and remaining with .ndf extensions.

    Test environment has 4 files with one .mdf and remaining with.ndf extensions.

    The problem is test environment is bigger in size than Production and its eating up lots of space on Server.

    please.............help me

  • Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic643123-5-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

You must be logged in to reply to this topic. Login to reply