OSQL compact database

please help
Osql command?
how can I compact a msde database
like I do with access database
osql -E -Q "DBCC SHRINKDATABASE (db_name)"
Jacco Schalkwijk
SQL Server MVP
"Carlos AZ" <CarlosAZ@.discussions.microsoft.com> wrote in message
news:5D9C3029-BA92-4954-BB2A-C683C1D09591@.microsoft.com...
> please help
> Osql command?
> how can I compact a msde database
> like I do with access database
>
|||Hi,
To add on to Jacco, do the steps below shrinking:-
1. Backup the transaction log if the database is not SIMPLE recovery
2. Use either DBCC SHRINKDATABASE or DBCC SHRINKFILE (See books online for
usage)
Thanks
Hari
SQL Server DBA
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid > wrote
in message news:ux%23r82nPFHA.1392@.TK2MSFTNGP10.phx.gbl...
> osql -E -Q "DBCC SHRINKDATABASE (db_name)"
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Carlos AZ" <CarlosAZ@.discussions.microsoft.com> wrote in message
> news:5D9C3029-BA92-4954-BB2A-C683C1D09591@.microsoft.com...
>