I love solving problems with handling time.

Daylight savings?

Multi-national? then dont forget different countries and timezones.

deep_kkumar (5/15/2012)

---

In logshipping........we save backup files on primary server and then copy these files to secondary server and then restore on the secondary server.

So my question was instead of saving...

Elliott Whitlow (5/15/2012)

---

I did something like this recently. It was a straight SQL 2008R2 to SQL 2008R2 move though due to a hardware replacement.

I brought up the new server...

mreynold (5/15/2012)

---

1) We'll need a test server

- I'm guessing this will need to be roughly a 500 GB box with 4-8 processors (that is comparable to...

deep_kkumar (5/15/2012)

---

We have space issue on Prod server.

I tested it we can save backup files and copy files on the same drive but what are the difficulties which we...

Renaming the server is possible but could cause problems especially as you are looking at decomissioning the old server at the same time

A DNS alias will work. Any replication...

DBA_AUS (5/14/2012)

---

thanks for your response guys. yes my aim is to point reads to node A and B and writes to Node A only. but to achieve this i need...

DBA_AUS (5/13/2012)

---

can someone please point me in right direction (links to articles)

i would like to impelment peer to peer replication with 2 nodes and allowing writes to be performed...

abatourab.ali (5/14/2012)

---

Hi All

i have tow servers each one has windows 2008 r2 std edition_64 and sql server 2008 R2 std edition_64.i plan to replicate my data frome server 1 to...

We sometimes get that. Restarting the distribution agent resets the counter

We use network compression hardware to speed up our replication to Australia. Without it would be shockingly slow. We still struggle occasionally with latency but then we do...

S_Kumar_S (5/8/2012)

---

ok, so the bottomline is don't create indexes on big table during peak hours.

Grant Fritchey (5/8/2012)

---

In general, this is one of those "Doctor, doctor! It hurts when I do...

Assuming you have Enterprise edition you can use the CREATE INDEX OPTIONS of ONLINE=ON and SORT_IN_TEMPDB=ON. These are my standard use for creating non clustered indexes.

These will allow all...

I've had to look this up. Its been some...

This is the definition of a left outer join which you are already...