Is your hard drive partitioned?

   you could be running out of space in the partition and need to move the log to another partition.

The transaction log has to keep...

1. Yes, the MASTER database contains information about the user database. But it's schema level information. The user database is self contained and can be moved to another SQL Server...

Using Enterprise Manager on the server that hosts the SQL Server, expand to the Instance. Right click on the instance and select Properties. On the General Tab, click on the...

I believe it's this way:

db_writer is the same as GRANT SELECT TO ...

db_denywriter is the same as DENY SELECT TO...

Why should you use the later instead of just not giving...

Are you growing the log file by percentage or MB? What size are you growing it by?

This can happen if the log file can't grow fast enough for the incoming...

What is the actual command you are using?

Are you telling it to put it on e: or e:\  ?

-SQLBill

We need some more information on this one.

1. How are you doing your backups?

   SQL Server commands to disk? to tape?

  Third-party software to disk? to tape?

2. Any other jobs...

Also, is your SQL Server patched to SP3a?

-SQLBill

Almost forgot - what size is the database you are trying to restore to MSDE?

-SQLBill

What version of SQL Server 2000 was it?

-SQLBill

You aren't going to be able to recover it via SQL. Even if you could backup the transaction log, you need a full backup to begin the restore.

You MIGHT be...

Here's another way to get rid of the extra space:

DECLARE @mystr VARCHAR(20)

SET @mystr = 'test [a] '

SELECT SUBSTRING(@mystr,1,(LEN(@mystr)-CHARINDEX(' ', (REVERSE(@mystr))))) + SUBSTRING(@mystr, (LEN(@mystr)-CHARINDEX(' ' , (REVERSE(@mystr))))+2, LEN(@mystr))

-SQLBill

Bruce,

It looks like you editted your post instead of Replying to the post. (The first post in the thread is a response to the second post in the thread).

If...

This sometimes happens because the statistics aren't updated.

Check the BOL for sp_updatestats.

-SQLBill

QUIT DOUBLE POSTING!

If people have an answer to your question they will post it. If you aren't getting an answer it's because:

1. no one has an answer

2. no one understands...