If it was the log file and the name was not exactly the same, it may have created a new log file on startup. Check the directory for another file,...

Usually there is a bit more with that error message which can help as well as things being logged to the Windows application log. I don't know if the network...

Sounds like this is an error you get in the error log when starting up SQL Server for one particular database? If that's the case, Is that the only error...

to be a resume generating practice. Our installation engineer is telling me that what is happening under the covers is a regular SQL backup, just the destination is the...

Check the provider you are using - the providers listed under Linked Servers just above the list of linked servers. Select the properties for the provider by right clicking and...

You might not need the quotes and likely need to follow four part naming conventions (Server.Database.Schema.ObjectName). So try without the quotes and adding another dot between cms196 and root so...

I've used that but I tend to use sys.dm_io_virtual_file_stats more often. Which way you go can depend on your work environment - as in some may not trust what SQL...

It's one of those that, as you have guessed, really depends on the volume of changes being tracked. We had tested some of that by using replay traces and running...

Yes, you can use CDC for incremental loading like that. The documentation has an overview of doing this:

Change Data Capture (SSIS)

There are quite a few articles with more details...

And I just did a quick run through some of those articles - this one seems fairly complete:

How to get up and running with Oracle and Linked Servers

Sue

Probably the issue. I have never heard of it being setup in that manner. I've always done mine to Oracle by downloading the version of ODAC (Oracle Data Access Components)...

Okay...that's a totally different error than the one originally posted. This one is an access denied error so it's however you setup the linked server to access the Oracle instance....

One thing I'd probably start with is go through the What's New In SQL Server <version> articles that Microsoft has in the documentation for the new releases. Here's the links...

I'm having a hard time following that but I'll give it a stab on the error message. I've seen that message before when they tried to access a database that...

My first guess would be that you have some process with the publication that generates a lot of changes during the week, what you refer to as the hiccups. Having...