Jones,

Take a transaction log backup and shrink the log file. Regular shrinking is not advisable as it causes fragmentation. Refer this link for more info,

http://www.sqlservercentral.com/Forums/Topic508854-357-1.aspx

No. That link actually describes the procedure to upgrade an existing log shipping configuration from Sql 2000 to Sql 2005. It does not deal with migrating/upgrading from Sql 2000 to...

I don't think that should be a problem..But without changing the compatability I don't think it is possible to use maintenance plan

[font="Verdana"]You can make use of the below command to change the database compatability,

sp_dbcmptlevel 'Dbname', 90

Refer this link for more info,

http://msdn.microsoft.com/en-us/library/ms178653.aspx[/font]

Inorder to avoid it you need to perform the following,

1. If your database is in Full/Bulk logged recovery model you need to take regular transaction log backups which will truncate...

Sethu,

I think you need to change the compatability of your Testdb to 80 or 90. Because the maintenance plan will not be able to backup the Sql 2005 databases which...

You need to rebuild the system databases to change the Sql server collation. You can use the below command to perform the same,

start /wait setup.exe /qn INSTANCENAME=”MSSQLSERVER” REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=”XXXX”...

Select serverproperty('productversion') will also provide you the desired result. Refer this link for more info,

http://support.microsoft.com/kb/321185

If the data changes rapidly in the source database then the snapshot might run out of disk space. If a database snapshot runs out of space, it is marked as...

You can verify the validity of your backup file by using the command,

Restore verifyonly from disk='Path\filename.bak'

If the backup file is valid then it can be restored in any other server...

You cannot install Sql 2005 EE in Vista or XP as it requires server OS like Windows 2003 or 2000 etc..However you can install Sql 2005 evaluation edition in both...

Hi Binu,

The restore is similar to normal restore. To restore system databases you need to have the same build and edition of Sql Server i.e example,

If your msdb full...

You cannot install Sql Server 2005 Enterprise edition in your Windows Vista. You need to have a server OS to accomplish the same. Refer this link for system requirements, http://technet.microsoft.com/en-us/library/ms143506.aspx

You can check the Sql Service account in the Sql Server configuration manager. Go to start - run - type 'Sqlservermanager.msc' and hit enter it will open the Sql server...

I think SNAC - Sql Server native client. The 1st link is for SNAC and the 2nd is for other components. So you have to apply both.