Lynn, very good question - I got it right mostly because I have been harping on the same thing that you have 🙂

For those interested, the other option for restoring...

Lynn Pettis (4/30/2010)

---

Not completely true regarding point in time recovery when using BULK_LOGGED recovery model. You can't use a t-log backup for point in time recovery where a minimally...

No - SQL Server databases cannot be opened like an Access database. They are managed by the SQL Server Database Engine which runs on a server. The mdf/ldf...

Shree_h (4/30/2010)

---

Eddy...

Assuming the Database is in full recovery and T-log backup job running every 30 min.. below steps can be followed while re-indexing..

1. Take a full backup.

2. Disable...

No, you cannot modify the index that way. You have to drop and recreate it to add additional included columns.

What you could do - and I am not guaranteeing...

Validate the folder location and whether or not you have checked the box to create a folder for each database. If that box is checked for the backups, the...

Jason - thanks, just never needed to do that myself.

I am curious about why you want to do this? Is there some reason you want to assign a static port instead of just using the dynamic ports?

Not sure...

I currently have one production database at 800GB - backed up and restored nightly to a report server. Backup takes ~1.5 hours - restore takes about 2 hours.

I also...

When you rebuild your indexes - do you by chance have the following setting?

STATISTICS_NORECOMPUTE = ON

I would also lean towards mirroring - with the caveat that you need Enterprise Edition and the ability to...

Think outside the box - I would rather say, get a bigger box 🙂

Here's an idea - download Redgates SQL Compare and SQL Data Compare. Use SQL Compare to...

Lynn Pettis (4/29/2010)

---

CirquedeSQLeil (4/29/2010)

---

Brandie Tarvin (4/29/2010)

---

Please tell...

Remove the . in the extension parameter. If you compare the above with the one that is working, you'll see the one...

From what...