So, if already exists, it will not return anything from the second sql. Because you are checking for not exists?

I thought that you want the path for Master DB only...

Do you already have Database named Test_Restore?

You are doing it right. What issue you are facing?

Instaed of if exists use "If NOT EXISTS"

Check for DB from sys. sysdatabases then get path from sys.master_files.

I would recommend to read through this. As Jeff & Oliiii said there may be numerous factors which maybe affecting it.

http://www.brentozar.com/sql/virtualization-best-practices/

I think it may be stuck on a certain dependency on something external to SQL Server or it may be a bug.

Check this out.

http://connect.microsoft.com/SQLServer/feedback/details/696484/unable-to-disable-server-audit-on-sql-server-2008-r2-sp1

Look at he Memory Manager. First Section.

VM Reserved

VM Committed

Have you given the ‘Lock pages in memory’ right to the account used by the SQL Server instance?

Also the task manager is not a right place to look for how...

You can also get that info from default trace file which SQL server maintains.

Open .trc file from your ...\MSSQL\LOG folder and search for the stored procedure which you are looking...

Have you tried it?

What version of SQL Server you are in?

It is a known issue SQL Server 2005 SP2. There is a ptch out to fix this issue.

But if you are in...

So could you be more specific? 2 servers- DO they have same databases/ different databases?

Which DB you are using to to create snapshot & where?

Have to tried replication instead of...

Compared to your environment, mine is really small. I have to support close to 50 prod Dbs.

I do not have any tools, I use batch scripts and SQL jobs to accomplish this. For our most critical applications, I do restore the backups in the Testing environments...

What kind of error you are getting? If you post the error message might be able to help you.

Thank you both Lowell & Sean for pointing my mistake out, I was thinking about the storing data & haven't read the post properly.