Hi Peter.

Do me a favour, do a quick test:

Lest use pubs, locate your database files eg.

C:\Program Files\Microsoft SQL Server\MSSQL\DATA\pubs.mdf

C:\Program Files\Microsoft SQL Server\MSSQL\DATA\pubs.ldf

Now comes the difficult bit. Stop SQL Server,...

Hi Steve

As a matter of interest have you ever tried getting a log file shrunk?

It would also help if you READ the post...

Full recovery model.

STEP 1: BACKUP Database

STEP 2: set...

You should be able to reattach the files with no problem if you can run the sp_attachdb statement. Don't know how you are going to do it in MSDE ......

Depends on what recovery mode your database is in.

If it is in simple recovery mode... run

BACKUP LOG databasename WITH TRUNCATE_ONLY

GO

CHECKPOINT

GO

You can run this twice to make sure then...

How did you get them copied in the first place? If the SQL service was stopped you should be able to reattach them.

If...

Get the sys admin to increase the event log size... from (Default is 512K) to .... 2 MB and then let him set the event log to be overwriten as...

Have you tried to connect to the server remotely?

Right click 'My Computer' -> Manage-> Right Click 'Computer Management' -> 'Connect to Remote Computer'

Doing this...

I would use text, id you are going to store 1000 rows with only one character in then you would waste the space, but for what you described test would...

The counter is SQLServer:Memory Manager Total Server Memory (KB)

Done the whole thing, noticed it did not report it on Task Manager. I used Performance monitor too see the actual memory used for the SQL server and this turned...