- Joined
- Sep 9, 2009
- Messages
- 179
- Reaction score
- 13
This is doing when you restored db ep3 on your mssql.
Choose database . Click choose tasks, choose shrink, choose database and click ok,
Now your db have decrease size.only <15mb....
case 2:
New query on that database and write
Dbcc shrinkfile(atum2_db_1,10)
Go
---And
Dbcc shrinkfile(atum2_db_account,10)
Go
--------------finished--
You can change 10 to 1.
Thanks for watching..
Choose database . Click choose tasks, choose shrink, choose database and click ok,
Now your db have decrease size.only <15mb....
case 2:
New query on that database and write
Dbcc shrinkfile(atum2_db_1,10)
Go
---And
Dbcc shrinkfile(atum2_db_account,10)
Go
--------------finished--
You can change 10 to 1.
Thanks for watching..