Hi Padma

Check your settings, connect your other server from your server where you have configured replication, this are the...

Hi Kiran

How many records are there in this table that you have created? have u got an...

One Answer BACKUP

If there is a good fail over plan then you will have answer for all your questions

Hope this helps 🙂

AS my friend recommanded there will be DATA LOSS, so think before to use this 🙂

try SQL Performance Dashboard, this gives you a overall picture of your server, and ways to improve performance 🙂

Check the quite time, speak to your management in terms of money( the language management understands) then they will start to think about the change of startegy 😀

There are various tools on the market for this job, MS is free and good as well 🙂

Hmm you can do that unless you are fine with the down time 😀

Hi Dejan

Try to Query from and other database on the source server and see of this...

to be honest, i dont belive in any specail softwares for this case, it always depends upon the network connection between servers, this is the base, if this is fast...

As Wilferd suggested, mirroring will be a best option, but this cannot be load balanced, read the link below to get a full idea about mirroring

http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

Hope this helps 🙂

Check the schema on the database you have created and Logins that are used to access Live database

Use SQL ( ha ha ha), can you be a bit more specific of ur requirements 🙂

Sorry , but this is not possible, is there any backup for this database at all, like a day old or something???

you have to be carefull before restarting SQL server, Make sure that there are more space for the database to restore itself, it takes some time for restore, as Giall...