Thanks Durai

Thanks alot Joie

Able to connect using

NET START MSSQLSERVER /f /T3608

Thanks for the reply.

I am local admin but still getting login failed error

Try This..

1.Turn ON the Auto-Close option for databases

2.Kill all connections

and then try to copy the files

Thanks a lot Steve..

I am blessed to get a reply from the great Steve.

Thanks Gail..

I gave dbcreator server role and ddladmin db role so that the user can create snapshot of only that particular existing userdb.

Thanks Lowell and thanks again for the Link

Thanks Lowell,

I want the process to keep running. Creating a recurring job wont help me.

Since am trying on test server DBCC CHECKDB wont take more than few seconds.

Thanks a lot J.

I havent tried this but i think it can be done if you give tables in database with different names atleast different schema name in different databases

try below query

SELECT

mid.statement

,migs.avg_total_user_cost * (migs.avg_user_impact / 100.0) * (migs.user_seeks + migs.user_scans) AS improvement_measure,OBJECT_NAME(mid.Object_id),

'CREATE INDEX [missing_index_' + CONVERT (VARCHAR, mig.index_group_handle) + '_' + CONVERT (VARCHAR, mid.index_handle)

...

Hope you adding the new file to primary filegroup

Thanks a lot it worked

I have admin previleage in that machine..

I stopped sql server and agent and started sql server using net start mssqlserver -m

when i tried to connect using SQLCMD -U domain\user -P...