Viewing 15 posts - 1,126 through 1,140 (of 6,400 total)
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. ...
February 19, 2020 at 7:56 am
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...
February 18, 2020 at 3:54 pm
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...
February 18, 2020 at 3:08 pm
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...
February 13, 2020 at 3:49 pm
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...
February 13, 2020 at 3:16 pm
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...
February 13, 2020 at 9:34 am
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...
February 13, 2020 at 9:14 am
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...
February 13, 2020 at 9:00 am
Replies to this thread please
https://www.sqlservercentral.com/forums/topic/restore-database-on-azure-vm-fails-2
February 13, 2020 at 8:53 am
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...
February 13, 2020 at 8:52 am
I too did 3, I was expecting XML, Graphical and Text as the answer
February 11, 2020 at 3:19 pm
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...
February 11, 2020 at 3:16 pm
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...
February 11, 2020 at 2:30 pm
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...
February 11, 2020 at 1:47 pm
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...
February 11, 2020 at 11:51 am
Viewing 15 posts - 1,126 through 1,140 (of 6,400 total)