You cannot for system databases but you can for user databases, by either backup\restore or detach\attach. Backup\restore preferred as backout is easier just in case.

So get everything at instance level...

try starting in multi user mode, connect and see if you can spot any other connections.

lets hope it was a non-serious post, but without the relevant emoticon or knowledge of the OP, hard to tell!

;-):ermm::unsure:

Timewarp gets another one!

http://www.sqlservercentral.com/Forums/Topic894352-32-6.aspx#bm901527

😛

did you also stop SQLAgent? Is this a cluster?

I feel the need to clarify that............

the activity so far will be in the log backup, but if you restore with recovery it will be rolled back if it had...

a transaction won't be part of a log backup until it is committed and therefore becomes inactive.

So if your update is one transaction none of it will be included in...

why use bcp at all? Whats wrong with a SQLAgent job that outputs to a text file?

That sounds easier and quicker than a C# routine and SMO 🙂

doesn't seem simple to me, looks fiddly and manual and therefore error prone.

I presume this is intended to be a one off process to update your copy of the...

If a restart was required the service pack would have requested one at the end of the install.

mark avis-234606 (4/8/2010)

---

What I still do not understand is why the data in the log file was very small (< 1GB) yet the transaction log backup files was ~40GB.

I thought...

If I understand correctly you are already switching to simple mode to shrink the log, so why don't you switch to simple, reindex, shrink log,switch to full, backup.

whether the reorganise...

Zahid Hasan (4/8/2010)

---

Thanks for the information. The databases we have on sql 2005 server doesn't grow too fast. i haven't figure out the growth rate yet. What i was concerning...

In bulk logged mode just a record of the extents moved as part of the reindex is recorded in the log, this could be a lot of extents, but as...

Glad we got there.

why the need to unpublish/republish? would a reinitialise not do?

What rates you offering for the job? :-D:-)