I have had the same problem with two of my clients with the Sharepoint_config database.

I think the Sharepoint recommendation for that database is to have it in Full recovery mode....

If the database is in full recovery model then make sure you take regular backups. That is the best way to keep the log file size in check. If you...

Hi,

If I see several lookups on a clustered index, is there a way to find which non clustered index is missing some columns?

I would like to...

Firstly, check the SQL Server error logs by directly opening the file in the install LOG directory. Find if you have any errors there.

Now to some basic questions.

1) Is this...

I don't think you will have to disable the replication on DB1 server where you are taking a backup.

But on DB2 where you are going to restore the database to,...

Run the following queries to find which file was the last one to be copied and which file was the last one to be restored.

The following query will give you...

Check this

http://saveadba.blogspot.com/2012/02/unable-to-start-execution-syntax-error.html

If you edit the job anytime in the future you will have to make this change again.

Firstly, I think that you are saving multiple files in one backup set. As Jeff has mentioned check your maintenance plan to make sure that you create new backup files...

1) I think you don't need to mention the DOT '.' in the extension for the files to be deleted. Just mention 'BAK' and it should work.

2) Not sure what...

What error do you get when you run the snapshot agent? Does it mention that it is expecting the history table to be also present on the subscriber?

If you are...

Try to run the snapshot agent job instead of using the replication monitor or any other tool in SSMS.

On one of my servers, the reports don't need data from the last 24 hours. So I have scheduled the restore job to run in the morning between 4 AM...

Evil Kraig F (2/7/2012)

I assume you mean the clustered index. Your PK can be nonclustered, and clustered index controls the Key Lookup information. The nonclustered indexes will remain...

If the table is not too large then it should be fine to move the primary key index while the non clustered indexes are still available.

If the table is very...

Quick question Gail.

What happens to the non clustered index on those tables if you move the primary key index to a new filegroup using the option that you mentioned?

If...