Backup/Restore because it is more consistent and safe. Copying the mdf/ldf file and attaching will work also, but if the mdf/ldf files were not detached properly - or just...

Robert Crouser II (4/30/2010)

---

Thank you. So for example you could not have a setup disk with a visual basic program and a sql server database the way you can...

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...