forked from dotnet/efcore
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathShrinkLocalDBModel.cmd
More file actions
14 lines (14 loc) · 1.07 KB
/
Copy pathShrinkLocalDBModel.cmd
File metadata and controls
14 lines (14 loc) · 1.07 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
@echo off
echo Shrinking the model database several times
sqlcmd -S "(localdb)\mssqllocaldb" -Q "DBCC SHRINKDATABASE (model) WITH NO_INFOMSGS"
sqlcmd -S "(localdb)\mssqllocaldb" -Q "DBCC SHRINKDATABASE (model) WITH NO_INFOMSGS"
sqlcmd -S "(localdb)\mssqllocaldb" -Q "DBCC SHRINKDATABASE (model) WITH NO_INFOMSGS"
sqlcmd -S "(localdb)\mssqllocaldb" -Q "DBCC SHRINKDATABASE (model) WITH NO_INFOMSGS"
sqlcmd -S "(localdb)\mssqllocaldb" -Q "DBCC SHRINKDATABASE (model) WITH NO_INFOMSGS"
sqlcmd -S "(localdb)\mssqllocaldb" -Q "DBCC SHRINKDATABASE (model) WITH NO_INFOMSGS"
sqlcmd -S "(localdb)\mssqllocaldb" -Q "DBCC SHRINKDATABASE (model) WITH NO_INFOMSGS"
sqlcmd -S "(localdb)\mssqllocaldb" -Q "DBCC SHRINKDATABASE (model) WITH NO_INFOMSGS"
sqlcmd -S "(localdb)\mssqllocaldb" -Q "DBCC SHRINKDATABASE (model) WITH NO_INFOMSGS"
echo Configuring model database to grow with default settings
sqlcmd -S "(localdb)\mssqllocaldb" -Q "ALTER DATABASE model MODIFY FILE (NAME=modeldev,FILEGROWTH=10%%);"
sqlcmd -S "(localdb)\mssqllocaldb" -Q "ALTER DATABASE model MODIFY FILE (NAME=modellog,FILEGROWTH=10%%);"