Rob,

Yes, there are an awful lot of options with SQL Backups and it can become complicated - but this is partly because of the power and flexibility that SQL Server provides (for...

Rob,

From what you say I suggest that you the following:

Set to Full Recovery mode.

Backup the database (FULL) each night.

Backup the Transaction Log to disk every 20 minutes during working...

Scott,

I think you meant to say that it does not shrink the physical Transaction Log file?

Of course this is true and my post is inaccurate in this respect. But although...

Rob,

Full Recovery mode:

You can restore up to the time of your last transaction log backup (you can also restore to an intermediate time which can ocassionally be useful).

You MUST...

I agree with Ian and Bryant regarding using a prefix such as usp_ to define a stored procedure. I always use object type prefixes where there is potential for ambiguity, so...

Whilst I agree with the general tenor of the article I have found that the suggested naming convention can become unwieldy when there are a large number of stored procedures in...

Ryan,

Vb6 (?) is perfectly fine linking to either JET (ie Access) or SQL Server - lots of articles out there to show you how to do this. However you have...

Microsoft provide an Access/JET to SQL Server upsizing tool - Not sure if the Access 97 one is still on their web site but take a look.

However I am not a...

When you talk of Access I assume that you mean JET - which is the native database engine for Access?

JET does not have Triggers (or Stored Procedures come to that)...

Marcel,

Using local copies of static or semi-static tables can be a help if you have a lot of drop down lists on a form. However make sure that you...

Many of the performance problems that arise after migrating Access to SQL Server are a result of the application not performing as a proper client/server system. Instead data is dragged...

Kyle,

The obvious solution is to use MSDE - this is the same core database engine as SQL Server but with a few restrictions (database size, number of users). As long...

Dale,

With regards to Briefcase Synchronisation the words "bargepole", "15 foot", "touch" and "don't" all spring to mind.

David Saville

Aldex Software Ltd.

http://www.aldex.co.uk

We developed a system to do something similar a couple of years ago.

Situation: 100 roving salemen with laptops producing estimates & quotes offline. Data needed to be sent back to...

You say that the existing database does not have Primary Keys on all tables - are you able to add PK's to the missing tables? Obviously you will need to...