What do you mean?!

ChrisM@Work (6/25/2013)

---

Abu Dina (6/24/2013)

---

ChrisM@Work (6/24/2013)

---

Abu Dina (6/24/2013)

---

This is still giving me problems! :unsure:

DECLARE @pairs TABLE (dropped_id INT, retained_id INT)

INSERT INTO @pairs

SELECT 16492, 23011 UNION ALL

SELECT 23011,24014 UNION ALL

SELECT 23011,24951...

ChrisM@Work (6/24/2013)

---

Abu Dina (6/24/2013)

---

This is still giving me problems! :unsure:

DECLARE @pairs TABLE (dropped_id INT, retained_id INT)

INSERT INTO @pairs

SELECT 16492, 23011 UNION ALL

SELECT 23011,24014 UNION ALL

SELECT 23011,24951 UNION ALL

SELECT 16492,24951...

This is still giving me problems! :unsure:

DECLARE @pairs TABLE (dropped_id INT, retained_id INT)

INSERT INTO @pairs

SELECT 16492, 23011 UNION ALL

SELECT 23011,24014 UNION ALL

SELECT 23011,24951 UNION ALL

SELECT 16492,24951 UNION ALL

SELECT 16492,29381...

GilaMonster (6/20/2013)

---

You mean 'don't reset the differential base', because that's all that a...

From MSDN (http://msdn.microsoft.com/en-us/library/ms191495.aspx)

Restoring a copy-only full backup is the same as restoring any other full backup.

Basically you use it so that...

You say:

So if it's just a couple of columns,...

Are you 100% sure you restored the correct backup?!

Have a look at this: http://ola.hallengren.com/

This is also great: http://www.sqlservercentral.com/articles/Backup+%2f+Restore/66564/

In the end I ended up impleneting my own solution after being inspired by http://sql-ution.com/download-the-dba-repository/ and http://sqlmag.com/sql-server/dba-repository-2010

This is the query I...

Have you tried the code I provided above?!

Do you have another backup file?

There is no need for a cursor to get the top 10 rows per port_portcode.

Try this (not tested due to lack of sample data though)

;with cTE AS (SELECT Port_Portcode,

Class_0_Minor_Description,...

You haven't provided enough information Tony.

Are you pulling data from multiple SQL instances/databases?

Are the SQL instances within a trusted domain?

I would look at using the Foreach Loop Container for this...

You welcome! 🙂

Isn't it just a case of adding an On Failure Action in the job and create an additional step in your job to perform the database restore?

BTW, why not take...