I mean BACKUP TRAN ?

SHould I be using BACKUP LOG ?

Do you have an automated Job defined to do yours ?

When you say backup I presume you do not mean...

Hi Frank,

I use the following statements when I import a large number of contacts:

DBCC SHRINKDATABASE('Omega_UK')

GO

BACKUP TRAN Omega_UK WITH TRUNCATE_ONLY

GO

Is this what you mean ?

Thanks

Mike

The tran log can also grow by the same portion 10%.

This is probably a stupid question but I will ask it anyway ! Is their a starting size of database...

Hi Allen & Frank,

Many thanks for your prompt reply greatly appreciated.

My database is 25MB and tran log 1 MB.

My tempdb is 14MB.

I allocated 30MB to the database, now it says...

Hi Andy,

I'm doing a similar thing to what you have listed except I'm doing my validation before the UPDATE, hence my variables will always hold the last values from the...

The TRUNCATE command looks an ideal one to use, however it does not deleting if their are any FOREIGN KEYS defined !

If I delete the data, and restablish the ID...

I was wondering why my transaction log is twice the size of the data file !

Are there any issues in adding 20,000 records into a database, taking them out and...

Works great.

Thanks for you help. Greatly appreciated.

Mike