Thanks michaela and Vidhya for correcting me..:)

You can use the below command to change the dbowner in Sql 2005 servers

ALTER AUTHORIZATION ON Database::databaseName TO serverPrincipal

sp_helpdb yourdbname will provide the necessary information..

Hi Chandramohan,

1. I think Select @@version will tell if it is x64 or x86

2. For restoring system databases you need to have the same build and same edition of Sql...

Go to Start - run - type 'Sqlservermanager.msc' and hit enter which will open Sql Server configuration manager. Click Sql Server 2005 services and in the right side it will...

Check for any open transactions using DBCC OPENTRAN('yourdbname')

Check for any open transactions using DBCC OPENTRAN('yourdbname')

Also check the log_reuse_wait column in sys.databases using the below command,

Use master

go

Select name,log_reuse_wait from sys.databases

go

No issues. While applying Sql Server service packs you will be prompted to select the instance to which SP2 needs to be applied. You need to choose the appropriate instance...

You need to identify what causes the disk space to be consumed. Check the database files and its most likely the log file which grows abnormally and consumes the...

Please...

Read through this link which describes the impact of regular shrinking,

http://www.karaszi.com/SQLServer/info_dont_shrink.asp

Can you check the permission to the database files in the path C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for the user with which you are running the setup. I think the user...

Take transaction log backup using the below command,

Backup log dbname to disk='Path\filename.trn'

Shrink the log file using the below command,

Use yourdb

go

Dbcc Shrinkfile('logfilename',500)

go

Without changing the compatability you cannot take t-log backup for the Sql 7 databases using the maintenance plan. But you can try using T- Sql,

Backup log dbname to disk='Path\filename.trn'

I guess you might have the Sql Server collation as case sensitive and hence the error. Can you try using xp_msver or XP_MSVER check the procedure and see the naming...