Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Need to create maintaince plan

Author  Topic 

sqlsutras
Starting Member

1 Post

Posted - 2010-05-04 : 05:29:43
How can we create an optimistic maintenance plan for the below mentioned scenario -

1. i do have one 1 TB of Database size
2. 500 GB of Transaction log file
3. my database is in replication mode with 7 publications and approx. 50 Subscription
4. Accessing Concurrent users 400 users
5. Transaction occurs 400 /sec
6. Batches 400 / sec

Thanks in advance/

Dhiva

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-04 : 11:55:17
What is an "optimistic maintenance plan"?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -