Is there a way to use this method, while also getting data from a MSSQL table, and inserting or updating MySQL ?? I'm guessing not.

I have another situation...

Worked perfectly. Run time from a minute down to 1 second. Thanks for explanation & solution

Great ! I think that's what I need. I will tweak it & test it .

haichells (11/10/2014)

I have a 2008 database where I take Full backup on Saturday and Log backup (once in a day) for rest of the days. Here my log backup files...

Server, Instance & database settings will will depend on the environment, and once set don't change.

So, I'm not clear on what you are looking for.

I do it this way. I run a script to generate the commands so I can verify I get the right ones. I script "Results to text", then copy-paste the...

Learning the script is good, but if they are all grouped together alphabetically, you can view them on Object Explorer, then highlight them all at once and click delete.

If you...

I did something like that at the time, putting the result...

Is this a production database ? If so, is "simple" recovery acceptable from a disaster recovery perspective ?

My boss is pretty sure that the pages they were hitting do not touch the database.

I'm going to pull the trace files for that time period and take a look...

SQLRNNR (7/31/2014)

In both cases, you can upgrade from 2000. I might even restore the database onto the 2008R2 box and leave it in compat 80 for a few weeks...

You could export to a file with BCP, or create a SSIS package.

Was the update cancelled intentionally ? Do you still need the update to occur ?

Next time, you could do the update in batches and take t-log backups regularly during...

Do some practice restores to another location. You can use the GUI to get all the settings in place, then "script to new query window".

This will show you the T-SQL,...

Did the restored database come from another server ? If so, there might be a SID mismatch for the user.