Post reply

shrinking database

  • June 11, 2003 at 10:43 am

    #82131

    Hello community

    I have one question about shrinking database when i use Sql enterprise Manager,when i right click and select option shrink database, the shrink databse form ask me "Maximum free space in files after shrinking".

    I think if i put in them yhe value of for example 30% and if my database can´t shrink with this value ,SQL Server use the best value for the operation.It is correct ?

    What can be happen if i exceed the maximun value for the shrink action ?

    Can i lost record or information.

    What ´s in your opinion the best practice.

    Thanks for yours replies

    Best regards

    Luis Santos

  • June 11, 2003 at 10:50 am

    #460819

    It's fairly well protected. If you exceed the max, it won't shrink that far.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

    http://www.dkranch.net

  • June 11, 2003 at 11:04 am

    #460826

    Thanks for your useful help

    I hope that all people that work with SQL SERVER count on you for many years because in my opinion this is the best community to help people that need to someone to her the better information about SQL SERVER.

    best regards

    Luis Santos

  • June 12, 2003 at 4:39 am

    #461023

    Have alook at using the DBCC ShrinkFile statement, rather that trying to shrink the entire database with a wizard. DBCC ShrinkFile works on a size parameter, rather than a a post shrink percentage of free space, so is both easier for yourself, and more efficient for sql server.

Viewing 4 posts - 1 through 3 (of 3 total)

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