You said "It's not in the same order" Do you mean when retrieving?

Tables are considered unordered in SQL. Unless you specify an ORDER BY in a select, there are no...

Straight from T-SQL, you can't. This is one of the valid reasons to use CLR procs.

Do you have the transaction log backups from the time of the last full backup?

Do you need to be able to restore that database to the point of failure (should a failure occur) or is it acceptable to restore to the last full backup?

If you have no indexes, then a read...

DTS packages are not stored in any of the user databases. They're stored in MSDB and backed up and restored along with that database, not the user databases.

Also sysindxes shows statistics, while sys.dm_db_index_usage_stats won't.

And don't truncate the log unless you are willing to throw log records away and lose the ability to do point in time recovery until another full/diff backup is taken.

I'd start by fnding out what those queries are running.

You can get the query/proc using the sys.dm_exec_requests and sys.dm_exec_query_text dmvs.

rinu philip (7/16/2008)

---

Hi, here's an example to explain : DBCC SHRINKFILE(testlog, 3)

Now if the target size is not reached with the above command, we can go on to truncate the...

Please don't cross post.

Also asked (and answered) here:

http://www.sqlservercentral.com/Forums/Topic534754-1291-1.aspx

Refer to thread:

http://www.sqlservercentral.com/Forums/Topic534754-1291-1.aspx

I explained it above.

Explain what you mean there please?

GilaMonster (7/16/2008)[hr

If you need to restore that database to a point after Tranlog backup 12, the restore paths are:

Full 1, Diff 2, Tran backups 5,6,7,8,9,10,11,12

Or

Full 2, Diff 4, Tran backups...