[dba-SQLServer] Hardware Upgrade ?

We did it by taking the .bak file and restoring it in the new system. You'll 
need to fix the users either way.. 

EXEC sp_change_users_login 'Auto_Fix', 'SqluserID', NULL, 'PWD'


On 8/5/05, Mike & Doris Manning <mikedorism at verizon.net> wrote:
> 
> I recommend detaching your databases, moving their files to the new SAN
> location, and then reattaching them. That strategy worked extremely well
> for us when we moved our data files out to our SAN.
> 
> Doris Manning
> Database Administrator
> Hargrove Inc.
> 
> 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 


-- 
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...