sql server programming: Anyone know where I can find example scripts that will compact, recover,
re-index etc... I am using vb.net, I would need to initialize it from there
or from my app that is...

Thanks,

Anthony Nystrom

Have you looked at the 'Database Maintenane Plan' wizard in SQL Server
Enterprise Manager?

You basically need to run commands like DBCC SHRINK*, DBCC DBREINDEX,
RESTORE etc, for the required tables/databases.

--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm




[quoted text, click to view]
Anyone know where I can find example scripts that will compact, recover,
re-index etc... I am using vb.net, I would need to initialize it from there
or from my app that is...

Thanks,

Anthony Nystrom