|
Home > Archive > MS SQL Server > February 2006 > SQL2000 rebuildm - wrong path
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL2000 rebuildm - wrong path
|
|
| hubi777 2006-02-28, 8:23 pm |
| I have installed a backup server with the German version of Windows2000 and
SQL2000.
By default, all program files are stored in the folder
“c:\Programme\Micr
osoft SQL Server\…\Data\”.
If a rebuild the master database with the rebuildm utility, the files are
copied to the “Programme\…\Dat
a\” folders, but if I try to start the
database, I get an error that the file model.mdf (msdbdata.dbf,...) could
not found in “c:\program files\Microsoft SQL Server\…\Data\”.
In the German version there is no folder “c:\program files” only
“c:\Programme\”.
Where is the path information stored and how can I change it.
| |
| John Bell 2006-02-28, 8:23 pm |
| Hi
What are the -d and -l command line parameters? Try staring SQL Server from
the command line with the correct parameters.
John
"hubi777" wrote:
> I have installed a backup server with the German version of Windows2000 and
> SQL2000.
> By default, all program files are stored in the folder
> “c:\Programme\Micr
osoft SQL Server\…\Data\”.
>
> If a rebuild the master database with the rebuildm utility, the files are
> copied to the “Programme\…\Dat
a\” folders, but if I try to start the
> database, I get an error that the file model.mdf (msdbdata.dbf,...) could
> not found in “c:\program files\Microsoft SQL Server\…\Data\”.
> In the German version there is no folder “c:\program files” only
> “c:\Programme\”.
>
> Where is the path information stored and how can I change it.
>
| |
| hubi777 2006-02-28, 8:23 pm |
| That's not the problem.
The master DB could be started with the correct path "Programme", but the
model DB was always searched in the wrong path "program files".
The SQL Server was installed by "MS Navision" experts, so i don't know what
they have done during installation.
"John Bell" wrote:
> Hi
>
> What are the -d and -l command line parameters? Try staring SQL Server from
> the command line with the correct parameters.
>
> John
| |
| John Bell 2006-02-28, 8:23 pm |
| Hi
If you use the trace flag 3608 when you start up you should be able to
attach the database from the correct location.
http://support.microsoft.com/kb/224...
21120120
You may need to detach it first.
John
"hubi777" wrote:
> That's not the problem.
> The master DB could be started with the correct path "Programme", but the
> model DB was always searched in the wrong path "program files".
>
> The SQL Server was installed by "MS Navision" experts, so i don't know what
> they have done during installation.
>
>
> "John Bell" wrote:
>
>
|
|
|
|
|