thank you for the great answer Craig Purnell

Thank you for the answer

i want to create 10 mirroring databases.but how many end points required.

could you please explain that question.

Hi All,

when we do any operation or transaction all are logged into log buffer.when you run the checkpoint save the all data to main database.

i understood .:-)

thank you for you are suggestion

thanks for the quick response

i want to move the all databases at a time is there any solution

thank you guys. it's working.

i have a one more doubt how to do server wide trace?

thank you

thank you for information

i will read the article later .how can find the slow running queries.

master0ONLINE

tempdb0ONLINE

model0ONLINE

msdb 0ONLINE

DBAAdmin 0ONLINE

another database not showing any thing.

thank you for all the suggestions

if we select database it's showing error. database is not operational

11 a.m backup job failed.

can i run dbcc checkdb(databasename ,repair_allow_data_loss)

hi,

thank you for the response.

i am having the yesterday backup 10p.m and every 1 hour log backups.

we can use the backups and restore the database up to...

database recovery model is full.

you have any idea .