Wednesday, March 21, 2012

How check database properties?

Hello, Everyone:
There are some databases in a SQL Server. How to check,
1. User database numbers
2. Backup plan
3. Configuration
4. User database size
5. Nightly process
Thanks a lot
ZYTsp_helpdb <DBname> should give you a broad overview of the database.

For the rest of the stuff you can use Enterprise Manager.sql

No comments:

Post a Comment