Viewing 15 posts - 31 through 45 (of 6,292 total)
Your sample file has no value for P8, so the data is correct according to your PNG & provided CSV.
March 5, 2024 at 9:29 am
Log shipping or write your own ETL routines are the only thing you can do which builds a delay into synchronisation.
But you want HA via AOAG, you cannot have a...
March 2, 2024 at 10:36 am
Get a copy of a WMI query, or get a WMI browser tool and try and run it as someone with admin rights, if the query fails because the namespace...
February 27, 2024 at 9:16 am
What HA technology are you using at the SQL level?
FCI or AOAG?
On an FCI the failover with replication should be seamless in a fashion, yes it will disconnect while failing...
February 22, 2024 at 9:07 am
Stick "SQL Server Monitoring Software" into your favourite search engine, you'll be presented with a abundance of results.
What you are asking for here is a monitoring piece of software, not...
February 20, 2024 at 10:26 am
Yeah, you can ask any question here as long as it is relevant, or in any of the version specific admin forums.
February 20, 2024 at 7:28 am
A bacpac is version agnostic. It is different from a BAK (backup). But bacpac have limitations, size being one of them. So if it’s a big DB then bacpac may...
February 19, 2024 at 5:19 pm
Script out all the tables and data via SSMS / Tasks / Generate Scripts, then replay the output script on a 2019 server.
Make a BACPAC of the database (may or...
February 19, 2024 at 4:40 pm
Replication you don't want to replicate the whole DB, that just asks for trouble. If you do replication, make sure its the core subset of what is needed and not...
February 16, 2024 at 2:34 pm
Replication or log shipping will be your only ones to be fair, although log shipping brings with it complexities about what to do if people are reporting and a log...
February 15, 2024 at 3:18 pm
You could check the default trace, but depending how busy your server is that data may have been lost by now.
Look for event 93 for log growths
92 - Data File...
February 15, 2024 at 10:09 am
You would have to dump the log backups using fn_dump_dblog to see what went on, but it's going to be a huge mess.
Sounds like you need to enable auditing, but...
February 15, 2024 at 9:56 am
CreateFile error 32 is something held a handle on the file and SQL couldn't delete it.
So something was reading/writing/touching the old audit file in some way.
Best thing you can do...
February 13, 2024 at 9:17 am
I wanna say its a bit like SSIS packages, drag and drop the things you need into the designer pane set the connection to the correct agent, give it the...
February 9, 2024 at 2:12 pm
Might be a bit to powerful for what you need but check out dSeries workload automation from Broadcom, used that in the past for this type of centralised job management/scheduling.
February 9, 2024 at 12:40 pm
Viewing 15 posts - 31 through 45 (of 6,292 total)