http://msdn.microsoft.com/en-us/library/aa933197(SQL.80).aspx

The tail log backup is the last of the log backups. Hence you restore it last.

You can restore it with recovery it you want, or with norecovery and then recover...

Means they are not currently running any queries.

First drop any constraints

ALTER TABLE <Table Name> DROP CONSTRAINT <Constraint Name>

Then drop the indexes

DROP INDEX <Index Name> ON <Table Name>

Then drop the column

ALTER TABLE <Table Name> DROP COLUMN <Column Name>

First the full backup, then the last differential, then all of the logs, in order. Restore them all with the NORECOVERY option then, once you're certain that you have all...

Nah. This one and the one you reference were started at the same time.

Shripad (6/1/2009)

---

Dear Paul,

I can restore the backup, its too easy to tell but its difficult to loose the data. My friends didn't took backup when i was on leave. I...

The line you posted looks fine. Please post the entire script.

If you want to know which tables your custom script has rebuild, add something in to the custom script to log that. If you want to see the fragmentation level...

As I said

When set to ON, the database is shut down cleanly and its resources are freed after the last user exits. The database automatically reopens when a user tries...

Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.

Shrinking causes massive fragmentation and will just result in the...

It won't be suspect anymore, but you'll still have lost all of your jobs, backup history, DTS packages, SSIS packages and whatever else is stored in msdb.

Personally, I'd rather say...

Books online says this:

When set to ON, the database is shut down cleanly and its resources are freed after the last user exits. The database automatically reopens when a user...

Table definitions, index definitions and execution plan (saved as a .sqlplan file, zipped and attached) please.

I'll be blunt, that query will not perform well and there's probably not much that...

_simon_ (5/31/2009)

---

My main entity in this model is Job, it contains Client, RoomNumber, Hookers, Services,... So one query would be which materials are used mostly and how often (condoms, lubricants,...