Thanks ,i will take a look into I\O Subsystem and update with my findings.

no i did not see that kind of issue.database ever had taken in single user mode or down for any time.

i do not see any other errors or warnings...

Yes, i agree with you, it is best practice, But my concern is there was any administrative over head implementing too many like 10 -15 different schemas in production environment...

sql 2005 management studio,

version MSSQL 2005 ,4035

Its trying to connect to just sql server 2005

sql 2005 management studio,

version MSSQL 2005 ,4035

Client Protocols set to no

and remote connections are open for tcp and named pipes.

i did not find that dynamic view in the master.

still though i have mssql 2005 install

What is different reportservertempdb, from tempdb

i donot see any difference in it.

then why we want to backup and restore it.

i may be missing important peace. correct me

Thank you very much, i realized my database was sql2000 version

i cannot use of it.

Thank you.

do you have example script for creating online index.

i know i can find it on books online but still...,

Users are having performance problems recently.

I have planned it do at off hours .

it makes any problem while creating it because table has

Many forien key relations.

How i can control the file sizes.

Here is my problem always i set Restricted file growth to both Data and Log files.but every day after restore job run it sets backs to unrestricted why ,

how...

Database need 2 gb space on disk to finish backup but on the disk has like 25 gb free space why it is happening then , after failing i rerun...

As you said when i open it in txt editor i see first four Letters are 'TAPE'

but when issue restore header only command it gave the below error

Server: Msg 3242,...