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)
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)
No comments:
Post a Comment