SQLism

Logging and Blogging SQL Server Experiences.

Wednesday, September 12, 2012

Error[21355] SQL-DMO: The new DB file size must be larger than the current size

Error[21355] SQL-DMO: The new DB file size must be larger than the current size.

Reduce the initial size of mdf file in sql server.



-- get the file#s / names of all the db's files
USE pubs
EXEC sp_helpfile




--Then choose the file# or filename you want to shrink. For example, to shrink the primary file to 2GB:


DBCC SHRINKFILE ( 1, 20000)
Posted by SQLism at 5:37 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: : The new DB file size, be, current, Error[21355], larger, must, size, SQL-DMO, than, the
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ►  2020 (6)
    • ►  July (1)
    • ►  March (1)
    • ►  February (4)
  • ►  2018 (3)
    • ►  August (3)
  • ►  2017 (10)
    • ►  December (1)
    • ►  October (1)
    • ►  June (1)
    • ►  May (1)
    • ►  February (4)
    • ►  January (2)
  • ►  2016 (7)
    • ►  December (1)
    • ►  November (3)
    • ►  October (1)
    • ►  September (1)
    • ►  August (1)
  • ►  2015 (10)
    • ►  September (1)
    • ►  April (9)
  • ►  2014 (53)
    • ►  October (19)
    • ►  September (33)
    • ►  June (1)
  • ►  2013 (12)
    • ►  October (2)
    • ►  September (1)
    • ►  August (5)
    • ►  July (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ▼  2012 (9)
    • ▼  September (1)
      • Error[21355] SQL-DMO: The new DB file size must be...
    • ►  August (6)
    • ►  July (2)
Simple theme. Theme images by luoman. Powered by Blogger.