BACKUP LOG WITH COPY_ONLY?

I would seriously suggest not doing that, it won't mark the log as re-usable.  I guess they have fixed it in 2016 if your getting an error. ...

You can. I'd suggest you read through the documentation for some of the how to. Don't bother with model (unless you're a unicorn and you're putting customization in...

A table in replication cannot be truncated, due to truncate being a minimal logged operation and this the full delete pages not logged in a fully logged operation so CDC...

Well have your looked at cross tabs as an alternative to pivot?

Post your query and we can see where its going wrong.

Just giving you the answer wont be good for...

Ok, what have you tried so far in the way of coding, to get to this goal?

What have you looked at in terms of syntax that you believe will accomplish...

If things are staying on the same server, then yes stored procs are a perfect way to do your requirements.

If things where going cross server, then things like linked servers...

There's not a lot of information here to go on.

Can you walk through the scenario your trying to describe?

From what I see it as you have a number of tables...

You would want to look at the DENSE_RANK() window function for this, ordered by the customer name.

If you still struggle, let us know, with what you tried and we can...

Replies to this thread please

https://www.sqlservercentral.com/forums/topic/restore-database-on-azure-vm-fails-2

Please don't cross post issues, it fragments the replies and makes it harder to manage.

Out of interest did the backup come from the same instance or was it from somewhere...

I too did 3, I was expecting XML, Graphical and Text as the answer

It should sort itself out when it you do all the needed "remove file" "add file" "alter file" commands.  You cant modify the system tables anymore (not that you should...

reverting backwards is the same as reverting forwards, just back to the original setting.

The <VALUE> field needs replacing with whatever sys.database_files, sys.master_files thinks the name of the tempdb mdf file...

I'd look at filestream and filetables personally, everything in the database, but separate in a way as its on its own filegroup etc.

Backups restores etc all flow as normal.

Obviously factor...

OK if that's how you want to play it that's fine, just remember you will get the rouge people who negate your wrapper code, so yeah it will happen, not...