We had a similar situation with one of our clients. But the difference was that the database got corrupted and full backup was performed. Subsequently the last good full backup...

It is difficult to move one database at a time and redirect the requests, without having to change the connection strings in the application code.

But if you moved all...

I know that you might have set up these tasks but I have seen a zillion times that the most basic database maintenance tasks are not set up properly.

Take...

Perfmon would be the best starting point to create a baseline.

I have attached a text file that you can use to create a performance counter. Save it as a...

Let us know if this helps. I would like to try that if I had to add filtering next time.

http://saveadba.blogspot.com/

I have experimented with adding new articles to an existing publication and successfully taken snapshot for just that one article. That way I can avoid taking snapshot for the entire...

I did similar research last week for a table on two columns not 3. Essentially I had 3 queries like this

Query 1) select col_pk from tab1 where col1=123

Query 2)...

In the beginning of the script there are three lines that you can edit.

-- Set Name of Database file to shrink

set @DBFileName = 'yourlogicalfilename'

-- Set Desired file free space in...

I have been successful in shrinking log files during production hours and not impacting the performance too much due to locking issues. I use a script that will shrink the...

In the missing index report there is a column called 'user_seeks' from the view sys.dm_db_missing_index_group_stats.

I have seen significant improvement only if the number of user_seeks is also high. Check that...

Have you tried creating a Login for that Windows account in SQL Server? I have seen that sometimes its best to explicitly create a Login for windows account instead of...

It seems that when I first created the endpoints on the mirrored server it created the endpoints on the default instance. This was because while connecting to the serve I...

Hi,

Thanks for your response but I was able to get this working. By making the following changes.

1) I split the list of table...

I was able to resolved this problem by creating a SQL Serve login for that windows user.

Before this it was part of the administrator group. Not sure if this will...

In the properties for the linked server, go to the security tab. Then map the local user, you are connected as, to a 'SQL SERVER login' on the remote server....