Very useful script.

Hi,

As suggested by ADIGA, use DTUTIL.

Seperate Disk for Tempdb will be good option in your case since it is being used extensively by application ( as mentioned by you).

Anyhow, if you have a bakcup of Secondary Database with copy_only option, the Backup will not be much of use, as the data on secondary db is a copy of...

There are service packs, feature packs, hot fixes and updates available

Hot Fixes are for one issue or may be more then one of similar nature. They are release frequently by...

Check the Authenication for Server3.

Also, hope that you are using Domain Account to login on the server ( not the Local system account).

Hi,

try to run performance monitor with memory related counter.

( Mostly Memory Manager -> Lock Memory, SQL Cache Memory, Target server Memory and Total Server memory).

Target server memory is the Memory...

@ravi-2,

Have u executed the the script?

Share the results.

There is issue with the MSDB Database. ( must be a Torn page on disk drive where the mdf of the msdb is stored).

Run Checkdb against the database and review...

Well, i think that it should make any impact on uninstallation of the sql 2005.

Well try it at your end and share the result.

Nicely crakced Issue.

@ravi-2,

Better try to do backup from Query

Backup database <Yourdb name> to disk=<'Path of the Physical disk.bak'>

for e.g.

Backup database model to disk='C:\Model_backup.bak'

TO find out Server Role for any user, following query can be used.

SELECT [name],sysadmin,securityadmin,serveradmin, setupadmin,processadmin,diskadmin,

dbcreator,bulkadmin,loginname FROM master..syslogins

WHERE loginname = '(Login)'

( in the output, all the roles with column valus as...

There is a wizard which will accomplish your task

Right click on the database, select script database as and then select either create, drop or drop and create option.

@tara-2

As per your blog, we have to disbale T-Log backup before starting Shirnk db or file operation.

But in the above question, Tlog backup is being executed before shrink...