If moving an index to a new file group, you have to recreate the index on the new location with drop option, and the corresponding statistics will be created and...

You plan to defragment indexes in the database and the links provide tools to do that. However, you may want to be familiar with the indexes before working on them....

Thanks, Gail Shaw.

Yes, it does. This type of backup is differential backup. Whenever a differential backup is created, it contains all the updated data since the most recent full backup. When a...

Sumanta,

It is more suitable to do this work with side-by-side migration. In other words, install the standard edition on another server and this is more appropriate solution; if you have...

Your description seems that your working database does not have a lot data growth in permanent tables but experiences a lot of expansion in the transaction log file each day....

I am unable to repeat what you described. If the problem persists, try to resart the SQL Server services to see if this takes care of the issue.

Whether it requires a dedicated server for the database, you need to consider its application importance, security, availability, performance, and manageability. Here are some thoughts for having a dedicated database...

You need to migrate the database to the new standard edition. The procedure itself should not be difficult but you need to plan it ahead to ensure the migration done...

It really depends on your usage and the database environment. If you have VLDBs, LiteSpeed is a great tool for such tasks as backup and restore; if you are running...

Sharepoint database likely holds commonly shared documentations. It will grow over time, although the growth rate is depending on the size and number of documents to be deposited into the...

Duplicate - Deleted.

I would not change the recovery model during production hours and this will allow the transaction data's integrity for recoverability. If this is an SQL Server 2005 environment and the...

To optimize your tempdb size, two things should be considered:

1) the estimate size for tempdb data files for daily operation, and

2) the required tempdb size for unplanned exceptions.

If the situation...

Correct! This is another reason.

Thanks,

Yichang