I am glad that worked. I have no idea changing from read_only to other mode and taking backup full backup would fix this, unless backup chain was broken. That error...

Down grade using attach\detach may not work, here is the work around.

Did you try exporting SSIS packages by connecting to Integration Services on SSMS to file? and do import on the destination server from the file.

This means you don't have base backup file to support tran log backup, You need full back up...

If you use DBCC shrinkfile option, You should be able to shrink the file size below initial size if there is unused space available in the file. Can you please...

Ok, then what is the Initial size and unused space on this file?

JDixon-385826 (3/17/2010)

---

running the below alter DB restricted user will make sure all transactions have been completed before the detach. Running something like the below will make sure you have as...

Why do want to shrinkdatabase? They are not big, even if you shrink it will expand if it is required.

what is the minimum size of the database?

CirquedeSQLeil (3/15/2010)

---

GTR (3/15/2010)

---

Because, if application users are try to make connection to database servers through application while performing upgrade for databases servers users receive error they cannot connect, and ton...

GilaMonster (3/15/2010)

---

GTR (3/15/2010)

---

GilaMonster (3/15/2010)

---

Really? Do you have any reference or...

CirquedeSQLeil (3/15/2010)

---

I would recommend something different than disabling IIS. We typically display a maintenance page and...

Alvin Ramard (3/15/2010)

---

GTR (3/15/2010)

---

GilaMonster (3/15/2010)

---

Really? Do you have any reference...

GilaMonster (3/15/2010)

---

Really? Do you have any reference or proof to...

What is the size of the databases?

Not necessarily, most of them do.