I ran the query and see the results ( attached )

Please see attached

Our new retore attempt has taken 1 hour and 17 minutes so far. I am going to give this 2 hours at least and check again.

Question: Can we run this...

Grant Fritchey (2/14/2011)

---

mw112009 (2/14/2011)

---

Let me make it simple.

When I started the "RESTORE.." I used the query window in SSMS.

Then 4 hours later when I logged back into the server I...

Here is the plan as of now..

One of our gurus uninstalled Sql server and then did a fresh installation.

We just started a new "RESTORE..." command. I wil get back with...

GilaMonster (2/14/2011)

---

mw112009 (2/14/2011)

---

Let me make it simple.

When I started the "RESTORE.." I used the query window in SSMS.

Then 4 hours later when I logged back into the server I did...

To be honest I don't know how to read error logs or event logs. Is there a sql statement that you can send us please ?

Let me make it simple.

When I started the "RESTORE.." I used the query window in SSMS.

Then 4 hours later when I logged back into the server I did not see...

You asked me about the Recover Model.

It was set to SIMPLE ( beofore I deleted quite a bit of records from several tables ).

Even now it is in SIMPLE mode

No I did nto run it in the production server.

We do have an intermediate sever ( It is a OLD PC that I loaded the OS and SQL sever...

I did run the DBCC_SHRINKDATABASE command and all that it did was increase the size of the unused space ( Took several hours by the way for this to complete...

The process is not slow.

I did the same ( using the same portable hard drive and the exact copy ) but using a server ( The server was a...

Is there a way to tell SQL sever to create a DB using the used space only ? Or is there a way to force SQL sever to cut down...

No can not copy the backup file to the server.

Reason: Our sever has very limited space. That...

restore database NGProd

from disk = N'D:\Backups\NGProd.bak' with file = 1,

move 'NextGen_System_Data' to 'D:\Databases\NGProd\NGProd_System_data.mdf',

move 'NextGen_Core_Data_1' to 'D:\Databases\NGProd\NGProd_Core_Data_1.ndf',

move 'NextGen_Index_1' ...

I did not use the GUI to do the restore.

I opened a query window and typed the "restore database ...."

command and clicked F5.

Shut down means you do not see SSMS...