Handling disspace issue for .mdf

  • How can i handle this situation , where I dont have diskspace for my Primary datafile(.mdf)for production environment?

    What are different options available to handle this situation in Sql server?

    Thanks in advance

    Ramesh

  • drop database??? No seriously, add disk or archive data are really your only viable options (maybe cleanup any unneeded "temporary" work tables?). Obviously, archiving data is going to require some sort of planning and, of course, testing of the process. Adding disk, depending on your server and it's setup, should be relatively easy. Never put yourself in this situation. Monitoring database growth and doing capacity planning is part of the DBA world. Never put your company, or your job, at risk by not being proactive.

    -- You can't be late until you show up.

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

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