the file constant is 300gb is there any way to decrease it.

Tanks for your reply.

here there is no open transactions. but I have checked the size in disk it is showing as 300gb. also we are not configured replication.

please help me on above questions

Thank u very much nagarajan. i will check and let u know.

HI

Thanks for u r quick response

I have changed the new path using startup parameters. here I have created new folder for new path.

but those are not mapped to service account...

Hi

thanks for your response.

here we are using windows8 and we are installing sqlserver r2.

what we found is we have installed the debug os on server due to that it is...

Thank you all now I understand the concept of cluster

thank u very much

thanks

but while installing I am getting error "a fatal error occurred during installation"

could u please help me out.

I am using sql 2008 and windows 2012 server

I want know exact difference between 2005 installation and 2008 installation

please provide the dmv's

Yes

Thank you very much

Here I am trying to execute the query and i will find the execution plan

here another option is also available

that is expected execution plan

Here after execution the above query it is showing some error

Msg 208, Level 16, State 1, Line 1

Invalid object name 'master.sysdatabases'.

it will give the complete information of those are backed up or single database information

Thank you very much