I've taken the data you posted and turned it into something that may actually resemble your data. Because you just copied it into your message it was one column, so...

Would it be possible to attach an extract from the actual file you're having difficulties with? A hundred or so records in the actual format the import is attempting to...

Does anyone know why it behaves like this? It appears to be at odds with any documentation I can find.

BrainDonor.

This isn't clear Ajay, do you mean you want to create a backup that is retained for 14 days or do you have a backup that has a 14 day...

This looks like you should use Cross Tab or Pivot to get the results formatted the way you want.

There are articles aplenty with this site that can explain it better...

This piece of code produces what you're after, for the example you give:

SELECT MAX(Cust_id),MAX(Title),MAX(First),MAX(Last),Add1,Town,MAX(Prod1),MAX(Prod2),MAX(Prod3),MAX(Prod4),MAX(Prod5)

FROM MergeTest

GROUP BY Add1, Town

I've taken the liberty of attaching a script that creates the table...

If you search the forums for 'backup 2005 2008' you'll find a couple of articles that explain why you can't do this via the normal backup routines.

Scripting the database and...

There is another interesting article by Gail Shaw:

http://www.sqlservercentral.com/articles/Indexing/68439/

The section on Index Limits may be of interest to you.

BrainDonor.

Thanks for that, both of you. It was looking at the execution plan and stats that made me suspect there's a misunderstanding about Views here. I found it hard to...

Backups and restores are too complicated. It's as if it has been created that way to make sure DBAs keep control of such areas, but I imagine it is just...

select @var1 = col1,

@var2=col2

from tab

BrainDonor

Yes you can. You can even install the SPs onto a 2000 server. You just have to make sure that you aren't using anything within the SPs that was introduced...

If they don't care about losing data input since the last full backup then probably not.

Generally, the Full Recovery is used because a Full backup takes more time than a Log backup. Systems that can't take the time to run a Full backup several times...

Thanks to you both, GSquared and Vaccano. I've played with both routines for a while and they both do what I need. Interestingly they have both rejected a couple of...