My task.

-Create daily backups of the changes made that day

-Apply those changes to a remote database

I would LIKE to log the actual code, but that doesnt seem possible.

I was planning on upgrading the database and tools to 2008 express edition along with upgrading soapware to the 2010 version.

This would at least allow updated functionality, something easier to...

Could this not do the trick... for now?

http://www.microsoft.com/sqlserver/2008/en/us/express.aspx

along with this.

http://www.microsoft.com/downloads/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en

?

If you dont mind me asking, why do I NEED the 2000 tools?

I have reviewed this information and I should be more than able to carry out the necessary step.

Thank you so much for your help.

Thank you all for your help.

I did not mean to make it seem as if I expect your help, it however seemed for a moment as if you had dissapeared,...

Someone please help me, I have 6 hours and I am running out of time.

I would greatly appreciate it.

BrainDonor (8/10/2010)

Webmaster, I did you a disservice - I assumed you were one...

Log Shipping for the purpose of DR is exactly what I'm looking at.

No offence taken, I am after all originally a programmer, so henceforth naturally I assume that If I...

He just up and left.

Now I am stuck with what I've been left to work with.

I know everything I need to know EXCEPT how to get the database to record...

I am the new NSA, and DBA, I am in training.

Making sure I secure the job requires that I learn at least exactly how to do this.

I can program, I...

I kind of need to be able to do this in 12 hours....

LOL.

But I will look around.

But I am still open to directions on how exactly to do it if...

I know nothing about backup models.

Basically what I want to do is

a)Create a full backup

b)apply this full backup to a remote server

Then every day from 00:01 to 20:00 monitor...

Is there not a simple script I can run on the server or even already programmed tool to do this?

Its a database used by an application called SOAPware.

It uses the whole database with data split up across different tables and databases.

Backing up ALL changes is relevant as the data...