> yeah, but you want to detach, then attach, since it will keep
> things concurrent...

I haven't needed to detach first if I just shut down the first SQL Server.
If I couldn't shut it down, I'd need to detach first. To the best of my
knowledge, all sp_detach_db does in addition to detaching the database is
update its statistics first, but it's not necessary to do that.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to