Thank you all for your most valuable suggestions . I have used the truncate table option to make the table complete empty and Gila Monster said it was taken only...

And also if possible, can you please tell me how much time it will take to truncate 5 million records

Thanks in advance...

Yes, i have to delete the complete data(~5 million) from the table . So can i go with truncate option?

Friends thanks for your replies, I gained good info.

By the way i have completed my activity(Rebooting Mirror for Patch upgrade) by Pausing Mirroring on 4 databases without any issues (thanks...

Thanks Perry...

But Please tell me what to do in case of below senario:

1. Databases are synchronised

2. I have paused the DB mirror

3. Started Reboot of Mirror...

Thanks for replies...

As my Database is in Simle recovery mode, i am not allowed to take the Log backup to clear the Log file.

And only 1% is in use in...

Thanks all for your valuable feedbacks.

Hi Beejug1983,

I need your help.

In my environment i have a 2 TB SQL 2005 Database and the DB is in SIMPLE recovery mode.

Now we are changing Simple to Full to...

Try to execute

SP_ResetStatus ---- to bring DB online

or

"Restore Database Database_name with Recovery" to bring the Database Online

Thanks for the reply. According to your reply if i am not wrong, all my sessions need to show in negative times but it is not.

Only one session...

Thanks alot for the reply...!!

My current environment:

SQL (Standard edition- 9.00.3042.00), WINDOW NT 5.2 (3790), 8 GB RAM, 8 Processors

My database are alredy devided into multiple(9) filegroups on different disk drives...