other than stopping sql service and starting it do we have any other alternate for that like bringing DB to offline instead of stopping the entire service????

yeah i got it

i had pasted the page_count value in this

page_count

204

2

4

2

2

3

2

2

2

2

3

3

3

3

4

4

2

How to identify that the indexes is for 2-3 pages ? if it is in that way can't i do reindexing for that ......???

I am getting the below error when i try executing the cmd

HResult 0x274C, Level 16, State 1

TCP Provider: A connection attempt failed because the connected party did not properly

respond...

it is listing only one server..."CMS" and that is wat i am trying connect and it fails

is it possible to view the previous hostname declared while installation.....????? bcos of this my service pack installation is getting stopped....can you help me to get rid of this

still it is not connecting ... because of this my service pack installation is getting failed at authorization check

Yes it is the same as the hostname..... i am getting a error like this "network related issue or instance specific error verify instance name is correct or it is...

i had tried for a single db and the path i gave as E:\ drive but still it behaves the same.....:-)

When i run it i am getting a success msg .... and the maintenance plan configuration is proper ....but it is not generating backup????????

I have totally 8GB of memory and out of which 6GB is allocated for SQL(Max setting for SQL)

no other application is running in that box other than SQL

in sp_who2 the coressponding blkby for spid 101 is 101 and in the corresponding command column it shows as killed/Rollback . Does it mean that the activity is getting rolled...

when i run the job there is no error getting generated in event viewer but the domainname\user has sysadmin as server role under security

Plese look into the msg below

Message

The job failed. The owner (domainame) of job Complete Backup.Subplan_1 does not have server access.

I had performed Select * from table name and it is showing all the columns with 0 rows but thee duration is abt 20 secs and my doubt is y...