Look up Transaction Log in the BOL. There's a pretty good description of how the active/inactive stuff works.

-SQLBill

Or ALTER DATABASE dbname SET MULTI_USER

-SQLBill

.ldf files are the log files. They keep track of all the transactions that occur on the database. If your database is set to SIMPLE recovery mode, then when...

First: I have the following update script:

No you don't. Both of those scripts are SELECT statements and don't update anything.

Second: Are you really trying to UPDATE something?

Third: Provide us...

As Kim states, with this type of question it's best if you gave us sample data. Show us a few lines of data (sample) as it would be in the...

Right click on the process and select Properties. That will show you all or most of what command is running.

-SQLBill

Do you mean - move a post to another forum? I don't think you can. You can post:

Do not answer here. This has been reposted in the appropriate...

Mark,

I don't know if you ever got a good answer or solved your problem, but....

The issue is with the Active part of the log. Let's say your log file...

First thing you need to do is decide how the space is being used. Open Enterprise Manager, expand until you see the database, single click on the db, then right...

You cannot backup the .mdf/.ndf/.ldf files while the database is online. They will not be restorable.

You have two options:

1. put the database offline and backup the files.

2. use SQL Server...

Talk to your sysadmins...they should be able to set up a 'cron' job (or something similar) to do what you are asking.

-SQLBill

Also, how are you doing the backups? Are the Full backups appending to the same file? Are the transaction logs appending to the same file?

I'm guessing that the full bu's...

Here's an issue with backups and restores. When transactions occur, the transaction goes into the log file. If there isn't enough room, the log file expands. Every so often, the...

It looks like some other restore is occuring when you try to do your restore.

-SQLBill

From the BOL...

To specify that the file should grow by a percentage of the current file size, select By percent and specify a value.

-SQLBill