I doubt how you connect to instance (Windows\SQL) would cause performance issues. You may want to check if any other processes running on the instance are slowing down this process.

If VSS is causing issues, it can be disabled from running. Instead you may want to increase the number of transaction log backups that you take, to make up for...

I have seen issues with VSS but it used to have "I/O is frozen..." messages in SQL Server Error Log. This is because VSS Writter issues BACKUP DATABASE ...with SNAPSHOT...

This article explains it nicely and it is the right place to start with.

This should work.

EXEC master.dbo.xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'DatabaseMailProfile', N'REG_SZ', N'MailProfileName'

It is always a best practice to restore system databases like master and msdb when you are moving SQL Server instance. It also avoids recreating the logins,jobs etc. If DTS...

As a temporary work around, it is ok to rely on file group backups. But it is always safe to have a full backup at regular intervals. You never know...

When the Volume Shadow Copy is running on the server, do you see any Error Messages in SQL Server Error Log/ Application Event Log?

There must be an open transaction running on the database which is filling up the database. Try running the below query to check if there are any running transactions.

SELECT *...

Yes there are quite a lot of new things introduced in SQL Server 2008 R2. Some of them are listed here[/url]

Mukunth-444251 (11/19/2010)

---

Hi I am new to SQL server Scheduler. I would like to know if there is any benchmark or data on the scheduler's performance. I am trying to evaluate...

Yes it is to a tape or Virtual Device

You may find this article[/url] useful.

If the name in Services is SQL Server (MSSQLServer) then it is a default instance. Hence the instance name in the connection string would be ServerName

If the name in Services...

Also make sure that the job owner is "sa" or some other user with sufficient privileges. Also ensure that the SQL Server/Agent startup account has privileges on the folder\files that...