GilaMonster (1/10/2013)

---

YSLGuru (1/10/2013)

---

Is it possible duing the restore to restore the DB so that it have a small amount of room to grow and not the full amount that the...

I was afraid of that. A 200GB+ DB can take a very long time (on a test/dev server) to shrink.

How about during the restore...

Mark,

I have not read thru the entire article yet and so this question may be directly answered in it but a quick skim thru it did not seem to indicate...

Lowel

Thank you for the reply but I'm not following how this can be used to get the answers I'm looking for. Could you perhaps provide an example using you...

I was hoping for somethingbuilt-into SSMS like a query option or similiar but I will test both suggestions made.

Thanks

GSquared (10/29/2012)

---

YSLGuru (10/24/2012)

---

Thanks for all the replies. In case it make a doifference heres the tables DDL . Its a very simple table.

The thing is a...

I just went to test out the ProofOfConcept UDf you provided...

Thanks for all the replies. In case it make a doifference heres the tables DDL . Its a very simple table.

The thing is a queue of...

Lowell (9/28/2012)

---

I'm pretty sure the settings are stored in the

%appdata%\Microsoft\SQL Server Management Studio\11.0 folder in the SQLStudio.bin file.

If you use any applications that clear out temporary files to recover...

What tips form Jeff? I just see one poast saying there is no such native funcationailty. did I miss a post?

Jeff Moden (10/23/2012)

---

YSLGuru (10/23/2012)

---

Thanks for the custom option Dixie but do you know if there is any native functinality in T-SQL that does this? What about in T-SQL 2012 if...

Thanks for the custom option Dixie but do you know if there is any native functinality in T-SQL that does this? What about in T-SQL 2012 if not in 2008?

Thanks for the recommendations Patrick.

Lynn Pettis (9/20/2012)

---

YSLGuru (9/20/2012)

---

Lynn Pettis (9/19/2012)

---

Bump. Have you tried my latest change? You know, not including the [ ] around the server name and instance name with the...

Lynn Pettis (9/19/2012)

---

Bump. Have you tried my latest change? You know, not including the [ ] around the server name and instance name with the -S parameter to...