RE: Can you change the name of the data file?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: jrpm (jrpm_at_discussions.microsoft.com)
Date: 12/08/04 

Date: Wed, 8 Dec 2004 07:25:03 -0800

1- What is the error message your are getting when you can't attach? What
does the log file say?
    I seem to remember having this problem a while back in EM. I closed EM,
then reopenned it. EM was keeping the old information and had to be flushed.

2- Try backing up the db, dropping it and then restoring it. In EM you can
then change the file names.

"DB" wrote:

> I want to change the name of the data file and
> corresponding log file. I detach, rename, then try to
> attach. It recognizes that the name has changed and
> won't allow me to attach.
>
> Thanks.
>

Relevant Pages

  • Re: How do i stop receiving duplicate emails?
    ... The log file is probably a hidden file, so you'll need to do a search for it ... Apparently you can't attach things when posting ... This posting is provided "AS IS" with no warranties, and confers no rights ...
    (microsoft.public.outlook.general)
  • Re: How do i stop receiving duplicate emails?
    ... Apparently you can't attach things when posting ... > Jeff Stephenson ... >> attached but i don't see the log file. ...
    (microsoft.public.outlook.general)
  • Re: Attaching a database, but missing a file
    ... you can attach without the log file and SQL Server will create a log file for you. ... IF the database doesn't attach, your option is to call MS Support and see if they have any emergency ...
    (microsoft.public.sqlserver.server)
  • Re: NT Service Problem
    ... Also I dont know how to attach a debugger to NT Service, ... there isn't really enough information here; you need to attach a debugger and catch ... The typical technique for a log file is ... The Service starts & stops successfully if I dont call this function. ...
    (microsoft.public.vc.mfc)
  • Re: Error 5173
    ... All permissions look correct. ... one .mdf and one .ldf that need to attach. ... log file somewhere else. ...
    (microsoft.public.sqlserver.server)