jwcolby
jwcolby at colbyconsulting.com
Thu Jul 19 12:32:23 CDT 2007
Never mind. I tried just renaming the files and reattaching them which (once I "found them" with file find) worked just fine. It set it up in the database tree as the old name. I then just renamed the file and voila. Sorry for the ring. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Thursday, July 19, 2007 1:03 PM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Renaming the database / files I want to rename a database, both at the file level and at the name level (what SQL Server sees it as). I am afraid to just rename the files themselves lest there be some something somewhere that causes it to fail to reattach. How is this done "the right way"? John W. Colby Colby Consulting www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com