You sure you posted complete error log?

Jayanth have rightly pointed about the consequences related to FK .

If you are not bothered about those and only want to move data better right custom script to move data...

Can you brief your configuration? Is it 2 node cluster and another server for AO?

Jeff Moden (10/25/2015)

---

Ratheesh.K.Nair (10/25/2015)

---

Jeff Moden (10/25/2015)

---

Ratheesh.K.Nair (10/25/2015)

---

Hi Experts,

We are observing very strange scenario in which some relationships are getting removed from tables. We havent deleted any tables? Can anyone...

Thanks Grant.

Eirikur Eiriksson (10/25/2015)

---

Ratheesh.K.Nair (10/25/2015)

---

Hi Experts,

We are observing very strange scenario in which some relationships are getting removed from tables. We havent deleted any tables? Can anyone help me understand...

Jeff Moden (10/25/2015)

---

Ratheesh.K.Nair (10/25/2015)

---

Hi Experts,

We are observing very strange scenario in which some relationships are getting removed from tables. We havent deleted any tables? Can anyone help me understand...

Thanks Jayanth , Will put an audit . Yes developers are...

Thanks everyone for the reply and sorry for the delayed response. DB went to suspect because of disk went offline. Another DBA went and rebooted the server and many other...

why DW needs high availability?

Why cant you have a good backup strategy in place and SQL clustering?

Thanks Alan and Bill,

The tables are accessed through out the day and this process is happening twice a day.

Which one is fast? Processing data and inserting it(currently taking 3...

spaghettidba (5/11/2015)

---

Looks like a good place for partitioning. If you can make your table partitioned on the predicate you use for deletes, gettin rid of that data can be a...

GilaMonster (5/11/2015)

---

Insert, maybe, delete no.

For the insert, maybe,...

Thank You

Should be able to .. Add the tape as Backup Device and then you can.