CirquedeSQLeil (4/6/2010)

pankaj.baluni (4/6/2010)

AT the time of DR, Storage team will bring up the LUNs for me at the DR Site and I'll turn the SQL servers on. Now as it...

Thanks to all of you for your valuable suggestions...

After reading all your responses, this is what I've come up with... Please tell if this will work for me or not....

PR...

ok... so you are saying I can have same server and...

DB Mirroring is good..... but I've a restriction that the instance name should be same as that of the primary server's instance.... please suggest.

PS has already addressed my previous question..and all other dobts.... so now i'm good to go... Many Thanks.

ok...

so please answer my first question that

if i have active/active clustering up & running in the production site between server 1 and server 2 then can I put Active/PAssive...

Yes, that is exactly what is was looking for.... and also many thanks for your suggestion that i would for sure... 🙂

Many Thanks.

Hi,

can you please put your reply question by question saying this needs to be scripted and this needs to be reconfigured...etc.. thanks...

Yes, SSAS DB Backup and Datawarehouse DB backups are one and same thing.... so my question is ... . Do we specifically need to take Cube backups when we have...

So r u saying we don't take Cube backups (specifically) but Datawarhouse DB's backups?

Is it not recommended to take Cube backups?

Try to re-install the latest service pack.. just uninsall and re-install the SP.

GRE-452109 (1/6/2010)

If log backup run for logs 3 and 4 but the copy job failed for logs 3 and 4, and the backup and copy process run sucessfully for Log...

Hello Experts,

Someone please help on this as it is very important and urgent.

log backup for log3 and log4 didn't happen. Appreciate your quick detailed reply on this.

Furthermore, if you can seperately mention the steps for all three, would be much appreciated......

select * from sys.databases would give you the DB creation date.

and you can query msdb..backupset DB to know when backups ran. It will show you the backup start date time...