jitendra.te (1/2/2013)
I have a Query Please help me out about this:Scenerio is, I have a database server which have a harddisk size is 70 GB c drives is occupied by OS. on which I have 2 databases DBA1 and DBA2 both database are live databases and configured in production environment.DBA1 and DBA2 are also configred with database mirroring without Automatic failover.
Now on my Primary server in C drive[Size=30GB] datafiles are configured which is .mdf format and in D drive[Size=30GB] have Logfiles are storing DBA1 logfile size is 12 Gb and DBA2 logfile size is 13GB and these logfiles are growing everyday 500MB.
i found this configuration a bit confusing , you are saying that you have single harddisk with size 70gb plus you are using the same in production ?
additionally you have mirrong setup too , what i am thinking here is apart from youre space issue you might be getting IO isssues too sooner or later.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)