Thanks Gail and Lynn

Thanks for the support till now.....I have a small question

I ran the Database Engine Tuning Advisor and in my Tuning Log file it says

Category ID __Event_____________________Statement___________Frequency____Reason

S001 ...

It worked if i select No Partitions

Regards,

Sandeep

Hey......Thanks for the reply......I have selected Full partitioning option(from Partitioning stratergy to employ Menu) but it shows the same error

Regards,

Sandeep

Finally i figured out the problem...its because of Blocking and Locking issues.......But i don't have much idea how to solve those issues.....Can u guys throw some light on it???

Regards,

Sandeep

I ran the following query

SELECT SUM(unallocated_extent_page_count) AS [free pages],

(SUM(unallocated_extent_page_count)*1.0/128) AS [free space in MB]

FROM sys.dm_db_file_space_usage;

and the results are

free pages ...

Does the database mirroring depends upon the structure of the tables??

(I am still in the process of learning the DBA tasks 🙂 )

I don't use any T-SQL statement for Database mirroring. I use GUI to create the endpoints....Initially i restored(only full backup) the database in principal server with recovery mode and i...

Yes, i did create the TCP endpoints and gave connect permission on both the servers

Yes, the SQL Server instances are running only on domain account

Guys....

Sorry for the late reply...i was out of town and couldn't reply.....

I believe my Database mirroring is not working properly.....I configured everything and when i click the start Mirroring button...

SRI,

My Principal Database is 2.5 GB(full backup) and Transaction Log Backup was 7.5 GB. I shrinked the Transaction Log Backup

and the size decreased to 24 MB....Initially when i was...

Thanks for the reply

@jeffrey......I thought the status of the mirror DB should be something like Mirroring, Synchronizing/Restoring....but in my case it says In Recovery....I checked the mirroring status in SSMS...

Hey,

Thanks for the reply....I did apply Hotfix and the Microsoft SQL error 1413 problem got resolved...but even now the mirroring process is not working properly....here is the problem

i configured the...