Microsoft generally recommends that you use a Storage Area Network (SAN) or locally attached disk for the storage of your Microsoft SQL Server database files because this configuration optimizes SQL...

Glad that it solved your problem!

I agree with Markus. You can make use of Transfer Job Task in SSIS to transfer all the jobs from principal server to mirror server. Refer this link regarding the...

Microsoft has published a KB based on this error message. Refer the below link, http://support.microsoft.com/kb/925976

1. As long as you perform DML operations in small chunks it should'nt be a problem.

2. Since the snapshot uses sparse files it the more modifications you perform to source...

If you are using Sql Server 2005 you dont need to worry 🙂

If you can start Sql Server in single user mode members of windows administator group will have sysadmin...

Can you please check the log_reuse_wait_desc column in sys.databases table in master database.

select * from sys.databases where name='Yourdbname'

Also if you perform backup log with truncate_only or no_log option it...

As mentioned above you can go ahead and setup log shipping it should be fine. We have configured for databases of which one is 700 + GB in size. It...

Refer this link, http://sql-articles.com/index.php?page=articles/msysdb.htm for moving system databases in Sql Server 2005. It also has screenshots which will certainly help you. For moving tempdb you need to use alter database...

The common reasons why a database would start recovering on its own are:

1. The SQL Service was shutdown from the Service Control Manager or due a server shutdown (which you...

Please refer these links and see if it helps,

http://www.sqlservercentral.com/columnists/ssamuel/2987.asp --- Inplace upgrade

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en --- Upgrade Document for SQL Server

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2534409&SiteID=1 - Upgrade from...

After installing SQL Server 2005. You need to apply the latest Service Pack which is SP2. The service packs are cumulative. There is no such order you can directly apply...

SQL Server database will be marked as 'Suspect' if the permissions for database files are missing. Also if the database files are being accessed by some other process while SQL...

[font="Verdana"]You cannot modify system tables in Sql Server 2005 normally but you can modify the same if you are connected using Dedicated Administrator Connection (DAC). Refer the below link regarding...

As already mentioned you need to restore as follows,

1. Restore the Full backup with NORecovery

2. Restore the 1stdifferential backup with Recovery

and check if the changes in Test1 are reflected in...