The information you provided is not sufficient. Please go through the article given below for better understanding on HA solutions.

Selecting a High Availability Solution

http://msdn.microsoft.com/en-us/library/bb510414.aspx

Grant Fritchey (11/23/2011)

---

WHOOP!

Best of luck.

While you're up at 3AM, after changing the diaper, just sit...

SqlNewJack (11/23/2011)

---

I am still here and appreciate every informative response. I read them via email updates which is why my previous login is dated. Thank you to all that have...

It seems they work independently.

Does a database backup/restore update statistics?

http://sqlserverpedia.com/blog/sql-server-backup-and-restore/does-a-database-backuprestore-update-statistics/

Paul... it's a good point actually. There are many threads in SSC where OP didn't care to inform that problem solved & XYZ gave the solution (XYZ is still waiting...

Having said all of that, converting DB2 and Oracle to SQL Server would be a serious project to undertake and you don't want to add an extra level of complexity...

Not Exactly. The thread is still...

I am kind of curious on what all information SQL Server Backup stores. Because I know in...

Rambler (11/23/2011)

---

Thanks GilaMonster, I'll try the recovery switch mode once again and see if it comes back again.

I'll do some additional HW diagnostics if it reveals something.

I was aware of...

How to set up and troubleshoot a linked server to an Oracle database in SQL Server

http://support.microsoft.com/kb/280106

One more question. Are you doing this with Maintenance Task? If yes please refer following (SQL Server Agent permissions).

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/c29711df-8042-4465-a3c0-20a1a3c9af0d/

Rambler (11/23/2011)

---

crazy4sql:

re 1) I'm fairly sure as I've ran chkdsk on the drive without errors. The drive is logical partition on RAID1 array and there are other databases and their...

SQL Server provides an API called Virtual Backup Device Interface (VDI) that enables independent software...

Gianluca Sartori (11/23/2011)

---

Good points, but you can achieve the same with schemas as well.

Dev (11/22/2011)

---

•It would be a Big Database so Big backup / restore files & requires...

Rambler (11/23/2011)

---

That was an immediate switch, the recovery model is Full ever since the switch.

The switch was made based on the following artictle: http://sqlskills.com/BLOGS/PAUL/post/How-can-a-log-backup-fail-but-a-full-backup-succeed.aspx

I know it breaks backup chain, but...