What I want to know is what steps should be taken to protect any data loss in between the snapshots that we take along with routine backup and restore task...

What I meant that does data physically move when we do switch operation.How switch operation work I wnated to know.can we do it when database is online???;-)

can you please explain what is logical operation in switching.Is it an online operation.

Well I have not got my answer as yet.I want to know if I am using AdevntureworksDW2008 database and view vTargetMail which has

Bikebuyer column that is my prediction column...

I have sa account and I tried to enable it but same problem not allowing to do any action error stating either sa account does not exists or user(machinename/administrator) do...

well I understand but there has to be some solution to it.It is asking me to use overloaded messagebox .show method for using windows handle.

NO it is just doing bulk inserts and running execute sql task with simple select statement.

I am working on my laptop so no other users also.

To try example I...

Thanks....

Thanks

:-)No I was not asking for any magic Bullet,I wanted to understand from scratch(the data itself)May be that was Data modelling which I was not aware.

Thanks

yes.but still not got clear abt it??

Thanks so much

yes I got your answer but still why public role exists when we have fixed database roles and user defined roles.what are the permission given to this role.

and regarding "sa"...

Well I was asked this question by an oracle guy where there is something dedicated and shared connection settings which can be controlled in oracle and I have no Idea...

let me make it clear what I want is u have

Server1 and two seperate instances

wherein db1 is mirroring with db2 ( endpoint MIrroring1)

now you have db3.....db4 mirroring session...