Log file size depends on its initial set, number of transactions in given period, backup maintenance plan (if you would shrink your log file), and transaction log (database backup will...

It seems that you should use log-shipping.

Before running DBCC commands, could we see anything? In short, could a user feel something wrong?

Many thanks

If a device is not allocated to a database, sp_dropdevice works. After allocating a device to a database, I got the error message: the device is in use!

Actually, I just...

DTS. It is powerful when you would like to change data type in data transformation.

Percentages differ from the cost. You need to check the total cost first, and then focus at the high percentage part to enhance performance.

Tom Goltl is correct. I did the test. The backup included all of activities during its process.

Based on the help, osql -L lists all servers in a current domain, not only SQL Servers. Am I right?

Many thanks in advance.

Did you try to execute the following commands?

dbcc traceon(1204)

dbcc traceon(1205)

I agree with Colin, do not set autoshrink. When a database is shrinking, you will get an error, log file is full, if someone sends a large transaction at this...

When I tried to use the Index Tuning Wizard, on the page to select Query Analyzer Selection, I found it was disabled. What I would like to know how to...

How to transfer DTS packages between servers?

There are 5 approaches doing it.

•

Open Design Package in DTS,...

Thank you for your inputs. But it seems that we still do not any have solution yet.

As far as I know, there is no significant difference using either function or view when using SELECT clause.

Using variable table is faster in general because it uses RAM,...

Did you try the table, sysdtspackages, in msdb for DTS packages, then, transfer the packages?