No answers just questions, When you back up your transaction logs do you do it with verify the integrity? Did you review the production side of this, the error...

I don't see how this helps - did you see

http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b275901

quote:

---

SQL 2000 sp 3

---

John...

What service pack

John Zacharkan

gfahrlander your mean!!! You kill without warning. I'm sure you'd make my internet community real happy.

John Zacharkan

quote:

---

Did you say you can do it in SQL Server 7.0?

---

On SQL 7.0 I...

quote:

---

Do you have to use maintenance plan to fix database minor problem? You can run dbcc checkdb with repair options and schedule...

How can that be an option in the database maint plan then?

quote:

---

Don't choose repair minor problem, that needs database in single...

Sounds like you have a few records. If you have enough disk add the varchar col under a different name, move the nvarchar to the new col; batch process...

I'll send you an example in the morning.

quote:

---

I don't think DTS will let me copy to the same server, unless I...

Sorry for the confusion.

You rename the system mdf & ldf database files after the services are stop.

Andy mention copying all mdf and ldf files. If you have a...

Please keep us posted!

John Zacharkan

hmmm DTS - one way

John Zacharkan

ps don't wait 24 hrs .

John Zacharkan

At this point I would kill the the spid restoring the database.

Does sp_who2 show you the restore in progress? If it does I would kill it, then delete...

From master - -Did you get this after you ran

RESTORE DATABASE yourdatabasenamehere With Recovery

quote:

---

Can't do anything with the database:

Server: Msg...