GilaMonster (3/19/2009)

---

That's a good one Gail. Explains everything just in 4 words.:-D

ALTER INDEX ‘indexname’ ON ‘tablename’ REBUILD

by default Rebuilding is OFFLINE unless you specify WITH clause as in:

ALTER INDEX ‘indexname’ ON ‘tablename’ REBUILD WITH (ONLINE=ON)

Yes, the VLF's are marked as truncated to make them reusable.

, but in order to use the log information...

By the way these codes are from Kalen daleney's Inside SQL server, I ahve used them and they are quite handy.

Use this query to check the TOP10 waits

SELECT TOP 10

wait_type,

waiting_tasks_count AS tasks,

wait_time_ms,

max_wait_time_ms AS max_wait,

signal_wait_time_ms...

shnex (3/19/2009)

---

So shrinking the log file has no side effects? Especially on performance

Because I want to shrink it but I'm affraid of unknown side effects.

I know that shrinking the database...

Oopps..thanks for correcting me Lowell. One of those days you see 🙁

MichaelJasson (3/18/2009)

---

Hello all,

I am getting follwoing error while taking backup on n\w as follows:

Backup device failed - Operating system error; Desc: BackupDiskFile::OpenMedia: Backup device '\\BY2STGOCSQL02\Z$\MSSQL.1\MSSQL\Log\FinalOctaneXmlDB\FinalOctaneXmlDB_backup_200903170800.trn' failed to open

I want...

:w00t::-D:hehe:

Do you know this wonderful tool Default trace?

You can enable it and script a table to load the trace files from the default trace to a custom created table....

Nope, There is no way to restore it onto a lower version. SQL server never downgrades a database to a lower version. the only option here we have got is...

It always advisable to...

Restore your 2000 backup file on 2005, it would be upgraded automatically.

Script out all your objects and then run them against your destination database.

Thanks for the feedback Paul.

However we should also investigate additional reasons that the log filled up in the...