Express allows 10GB. You can test it there. It will just stop you from adding more data

Do you have any way of determining what is the "correct" row to keep? Is there a PK, and can you provide some DDL for the table?

The GUI has issues, and "remembering" previous files is one.

I would stick with .bak and .trn, just so that no one is confused.

Alright, everyone behave. I'm knocking off early to go drink some beer with the SQL Sentry guys.

Have a great weekend.

Is that Klingon?

Great advice from Wayne, and if you search for Gail, she has a great article on managing transaction logs on this site.

I think you're confused a little on log shipping.

The way log shipping works on the primary

- Make a full backup

- Make log backups

- Make periodic full backups

It just runs.

On the...

It could. There's a lot of different ways that SANs work. You can contact your vendor, but if the drives aren't set for dynamic expansion, you might need to bounce...

To update a database, attach (or restore) the files on the higher version server. If you are looking to upgrade your entire instance, then run the Upgrade Advisor, and then...

http://msdn.microsoft.com/en-us/library/ms174763.aspx

I don't want a cookie. Not really my thing.

Now this....

Why not take your full backup and restore it on the remote instance? Depending on activity, the VSS service can be problematic. You are attempting to freeze two files and...

All good suggestions. ultimately you cannot start a remote job from your local SQL Server instance without opening a connection on the other instance. Your instance has no control over...

If you don't need this in a single transaction, you can try updating batches of rows. Sometimes that is quicker than one large update.

Can you post the error?