Moving The Distribution Model Files

I am currently moving the system databases data and log files to different drives. I know how to move the master, model, log, and tempdb but can find no documentation on how to move the distribution model files (distmdl.mdf and distmdl.ldf). Does anyone k
now how these files should be moved? As an added note, we are not currently using distribution, but the files still exist. Any information would be greatly appreciated.
Just copy them to where you put master. You don't actually need them to set
up replication but it makes it a lot faster (the set up that is, not
replication in general) as otherwise it has to create it all from scripts.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:CDCA750A-64C7-4A6D-B985-C06BBA09DFC2@.microsoft.com...
> I am currently moving the system databases data and log files to different
drives. I know how to move the master, model, log, and tempdb but can find
no documentation on how to move the distribution model files (distmdl.mdf
and distmdl.ldf). Does anyone know how these files should be moved? As an
added note, we are not currently using distribution, but the files still
exist. Any information would be greatly appreciated.
>
|||Jasper, Thanks for the quick reply. I searched all over the KB and could find nothing about this.
Mike C.
"Jasper Smith" wrote:

> Just copy them to where you put master. You don't actually need them to set
> up replication but it makes it a lot faster (the set up that is, not
> replication in general) as otherwise it has to create it all from scripts.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "MACason" <MACason@.discussions.microsoft.com> wrote in message
> news:CDCA750A-64C7-4A6D-B985-C06BBA09DFC2@.microsoft.com...
> drives. I know how to move the master, model, log, and tempdb but can find
> no documentation on how to move the distribution model files (distmdl.mdf
> and distmdl.ldf). Does anyone know how these files should be moved? As an
> added note, we are not currently using distribution, but the files still
> exist. Any information would be greatly appreciated.
>
>
|||I would leave those distribution template databases where they were. But if
you are also changing the default database and log folders, then copy these
templates into those folders.
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:CDCA750A-64C7-4A6D-B985-C06BBA09DFC2@.microsoft.com...
> I am currently moving the system databases data and log files to different
drives. I know how to move the master, model, log, and tempdb but can find
no documentation on how to move the distribution model files (distmdl.mdf
and distmdl.ldf). Does anyone know how these files should be moved? As an
added note, we are not currently using distribution, but the files still
exist. Any information would be greatly appreciated.
>

Moving The Distribution Model Files

I am currently moving the system databases data and log files to different d
rives. I know how to move the master, model, log, and tempdb but can find no
documentation on how to move the distribution model files (distmdl.mdf and
distmdl.ldf). Does anyone k
now how these files should be moved? As an added note, we are not currently
using distribution, but the files still exist. Any information would be grea
tly appreciated.Just copy them to where you put master. You don't actually need them to set
up replication but it makes it a lot faster (the set up that is, not
replication in general) as otherwise it has to create it all from scripts.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:CDCA750A-64C7-4A6D-B985-C06BBA09DFC2@.microsoft.com...
> I am currently moving the system databases data and log files to different
drives. I know how to move the master, model, log, and tempdb but can find
no documentation on how to move the distribution model files (distmdl.mdf
and distmdl.ldf). Does anyone know how these files should be moved? As an
added note, we are not currently using distribution, but the files still
exist. Any information would be greatly appreciated.
>|||Jasper, Thanks for the quick reply. I searched all over the KB and could fin
d nothing about this.
Mike C.
"Jasper Smith" wrote:

> Just copy them to where you put master. You don't actually need them to se
t
> up replication but it makes it a lot faster (the set up that is, not
> replication in general) as otherwise it has to create it all from scripts.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "MACason" <MACason@.discussions.microsoft.com> wrote in message
> news:CDCA750A-64C7-4A6D-B985-C06BBA09DFC2@.microsoft.com...
> drives. I know how to move the master, model, log, and tempdb but can find
> no documentation on how to move the distribution model files (distmdl.mdf
> and distmdl.ldf). Does anyone know how these files should be moved? As an
> added note, we are not currently using distribution, but the files still
> exist. Any information would be greatly appreciated.
>
>|||I would leave those distribution template databases where they were. But if
you are also changing the default database and log folders, then copy these
templates into those folders.
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:CDCA750A-64C7-4A6D-B985-C06BBA09DFC2@.microsoft.com...
> I am currently moving the system databases data and log files to different
drives. I know how to move the master, model, log, and tempdb but can find
no documentation on how to move the distribution model files (distmdl.mdf
and distmdl.ldf). Does anyone know how these files should be moved? As an
added note, we are not currently using distribution, but the files still
exist. Any information would be greatly appreciated.
>

moving system db's to new location with different logical drive letters

Hi, my requirement is to move a host of databases (including the systems
databases) to a new storage unit which will have new logical drives. Now I
followed the process of detach/attach as per article:
Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
I managed to move the databases in the order: model, msdb, temp (via ALTER
DATABASE). At this point SQL managed to start.
I then went to perform the master database relocation step via changing the
parameters in the startup parameters in EM, but my SQL would not start. So I
knew it was my master database which was the problem.
What I found was that I could not use the previous master db as it still had
references to model, msdb etc with the old drive letter. I could not simply
move the model and msdb files to this old drive letter as the drive letter
did not exist on the new storage unit.
My questions...
How do I modify my old master to reference the system databases based on the
new drive letters/location?
If i cannot do this, I am guessing I can use the new master db, however I
would need to change some of the system database files referencing in
sysdatabases, sysaltfiles and sysdevices? In addition I would need to script
out my logins as this obviously isnt attached with the new master, but with
the old master. After this process I should be set right?
Any help most appreciated.
Thanks.
JaneWhat I forgot to mention was the fact that these moved databases will not be
referenced by the old SQL server (serverA), but by a new instance of SQL on
another PC (serverB). So what I'm doing is the following:
Old configuration: serverA --> G:\myDatabaseFiles
New configuration: serverB --> Z:\myDatabaseFiles
ServerA cannot see Z: drive
ServerB cannot see G: drive
Any help most appreciated.
Kindest regards,
Jane
"Jane Richardson" <J.Richardson@.melgrave.com.au> wrote in message
news:e2Q$dge8FHA.500@.TK2MSFTNGP15.phx.gbl...
> Hi, my requirement is to move a host of databases (including the systems
> databases) to a new storage unit which will have new logical drives. Now I
> followed the process of detach/attach as per article:
> Moving SQL Server databases to a new location with Detach/Attach
> http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
> I managed to move the databases in the order: model, msdb, temp (via ALTER
> DATABASE). At this point SQL managed to start.
> I then went to perform the master database relocation step via changing
> the parameters in the startup parameters in EM, but my SQL would not
> start. So I knew it was my master database which was the problem.
> What I found was that I could not use the previous master db as it still
> had references to model, msdb etc with the old drive letter. I could not
> simply move the model and msdb files to this old drive letter as the drive
> letter did not exist on the new storage unit.
> My questions...
> How do I modify my old master to reference the system databases based on
> the new drive letters/location?
> If i cannot do this, I am guessing I can use the new master db, however I
> would need to change some of the system database files referencing in
> sysdatabases, sysaltfiles and sysdevices? In addition I would need to
> script out my logins as this obviously isnt attached with the new master,
> but with the old master. After this process I should be set right?
> Any help most appreciated.
> Thanks.
> Jane
>
>
>
>

moving system db's to new location with different logical drive letters

Hi, my requirement is to move a host of databases (including the systems
databases) to a new storage unit which will have new logical drives. Now I
followed the process of detach/attach as per article:
Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/default...b;en-us;224071
I managed to move the databases in the order: model, msdb, temp (via ALTER
DATABASE). At this point SQL managed to start.
I then went to perform the master database relocation step via changing the
parameters in the startup parameters in EM, but my SQL would not start. So I
knew it was my master database which was the problem.
What I found was that I could not use the previous master db as it still had
references to model, msdb etc with the old drive letter. I could not simply
move the model and msdb files to this old drive letter as the drive letter
did not exist on the new storage unit.
My questions...
How do I modify my old master to reference the system databases based on the
new drive letters/location?
If i cannot do this, I am guessing I can use the new master db, however I
would need to change some of the system database files referencing in
sysdatabases, sysaltfiles and sysdevices? In addition I would need to script
out my logins as this obviously isnt attached with the new master, but with
the old master. After this process I should be set right?
Any help most appreciated.
Thanks.
Jane
What I forgot to mention was the fact that these moved databases will not be
referenced by the old SQL server (serverA), but by a new instance of SQL on
another PC (serverB). So what I'm doing is the following:
Old configuration: serverA --> G:\myDatabaseFiles
New configuration: serverB --> Z:\myDatabaseFiles
ServerA cannot see Z: drive
ServerB cannot see G: drive
Any help most appreciated.
Kindest regards,
Jane
"Jane Richardson" <J.Richardson@.melgrave.com.au> wrote in message
news:e2Q$dge8FHA.500@.TK2MSFTNGP15.phx.gbl...
> Hi, my requirement is to move a host of databases (including the systems
> databases) to a new storage unit which will have new logical drives. Now I
> followed the process of detach/attach as per article:
> Moving SQL Server databases to a new location with Detach/Attach
> http://support.microsoft.com/default...b;en-us;224071
> I managed to move the databases in the order: model, msdb, temp (via ALTER
> DATABASE). At this point SQL managed to start.
> I then went to perform the master database relocation step via changing
> the parameters in the startup parameters in EM, but my SQL would not
> start. So I knew it was my master database which was the problem.
> What I found was that I could not use the previous master db as it still
> had references to model, msdb etc with the old drive letter. I could not
> simply move the model and msdb files to this old drive letter as the drive
> letter did not exist on the new storage unit.
> My questions...
> How do I modify my old master to reference the system databases based on
> the new drive letters/location?
> If i cannot do this, I am guessing I can use the new master db, however I
> would need to change some of the system database files referencing in
> sysdatabases, sysaltfiles and sysdevices? In addition I would need to
> script out my logins as this obviously isnt attached with the new master,
> but with the old master. After this process I should be set right?
> Any help most appreciated.
> Thanks.
> Jane
>
>
>
>
sql

moving system db's to new location with different logical drive letters

Hi, my requirement is to move a host of databases (including the systems
databases) to a new storage unit which will have new logical drives. Now I
followed the process of detach/attach as per article:
Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/defaul...kb;en-us;224071
I managed to move the databases in the order: model, msdb, temp (via ALTER
DATABASE). At this point SQL managed to start.
I then went to perform the master database relocation step via changing the
parameters in the startup parameters in EM, but my SQL would not start. So I
knew it was my master database which was the problem.
What I found was that I could not use the previous master db as it still had
references to model, msdb etc with the old drive letter. I could not simply
move the model and msdb files to this old drive letter as the drive letter
did not exist on the new storage unit.
My questions...
How do I modify my old master to reference the system databases based on the
new drive letters/location?
If i cannot do this, I am guessing I can use the new master db, however I
would need to change some of the system database files referencing in
sysdatabases, sysaltfiles and sysdevices? In addition I would need to script
out my logins as this obviously isnt attached with the new master, but with
the old master. After this process I should be set right?
Any help most appreciated.
Thanks.
JaneWhat I forgot to mention was the fact that these moved databases will not be
referenced by the old SQL server (serverA), but by a new instance of SQL on
another PC (serverB). So what I'm doing is the following:
Old configuration: serverA --> G:\myDatabaseFiles
New configuration: serverB --> Z:\myDatabaseFiles
ServerA cannot see Z: drive
ServerB cannot see G: drive
Any help most appreciated.
Kindest regards,
Jane
"Jane Richardson" <J.Richardson@.melgrave.com.au> wrote in message
news:e2Q$dge8FHA.500@.TK2MSFTNGP15.phx.gbl...
> Hi, my requirement is to move a host of databases (including the systems
> databases) to a new storage unit which will have new logical drives. Now I
> followed the process of detach/attach as per article:
> Moving SQL Server databases to a new location with Detach/Attach
> http://support.microsoft.com/defaul...kb;en-us;224071
> I managed to move the databases in the order: model, msdb, temp (via ALTER
> DATABASE). At this point SQL managed to start.
> I then went to perform the master database relocation step via changing
> the parameters in the startup parameters in EM, but my SQL would not
> start. So I knew it was my master database which was the problem.
> What I found was that I could not use the previous master db as it still
> had references to model, msdb etc with the old drive letter. I could not
> simply move the model and msdb files to this old drive letter as the drive
> letter did not exist on the new storage unit.
> My questions...
> How do I modify my old master to reference the system databases based on
> the new drive letters/location?
> If i cannot do this, I am guessing I can use the new master db, however I
> would need to change some of the system database files referencing in
> sysdatabases, sysaltfiles and sysdevices? In addition I would need to
> script out my logins as this obviously isnt attached with the new master,
> but with the old master. After this process I should be set right?
> Any help most appreciated.
> Thanks.
> Jane
>
>
>
>

moving system databases

Hi all.
Long story, I have a clustered SQL Server 2005 Standard Edition that is
using a SAN. We have just added more drives to our SAN and I need to move
the system database off the current drive to another drive. I have read some
others that have too have asked the same question. And Article ID 224071
keeps coming up. Well I just tried following this article this morning on my
beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
production and after I tried changing the startup parameters and tried
starting SQL server instance backup I received the following error.
FCB::Open: Operating system error 2(The system cannot find the file
specified.) occurred while creating or opening file 'F:\Program
Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
Diagnose and correct the operating system error, and retry the operation.
And after a Google search I ran across an article out on MSDN, saying that
you need to use a ';' in between the parameters.
http://msdn2.microsoft.com/en-us/library/ms190699.aspx
I had to use SQL Server Configuration Manager to change the startup
parameters because there was no 'startup parameters' under the general tab
under Enterprise Manager (I had 2 other people check the steps out too and
they couldn't find it either).
Did I do something wrong? Should there be ';' between the parameters or not?
Thanks in advance!
Kris
If it helps, my SQL 2005 startup parameters from teh Config manager:
-dC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
Or check in the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.1\MSSQLServer\Parameters
Kevin Hill
IC3 North Texas
www.ChristianCycling.com
Please support me in the 2008 MS150:
http://www.ms150.org/dallas/donate/donate.cfm?id=208000
"Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
> Hi all.
> Long story, I have a clustered SQL Server 2005 Standard Edition that is
> using a SAN. We have just added more drives to our SAN and I need to move
> the system database off the current drive to another drive. I have read
> some
> others that have too have asked the same question. And Article ID 224071
> keeps coming up. Well I just tried following this article this morning on
> my
> beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
> production and after I tried changing the startup parameters and tried
> starting SQL server instance backup I received the following error.
> FCB::Open: Operating system error 2(The system cannot find the file
> specified.) occurred while creating or opening file 'F:\Program
> Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
> Diagnose and correct the operating system error, and retry the operation.
> And after a Google search I ran across an article out on MSDN, saying that
> you need to use a ';' in between the parameters.
> http://msdn2.microsoft.com/en-us/library/ms190699.aspx
> I had to use SQL Server Configuration Manager to change the startup
> parameters because there was no 'startup parameters' under the general tab
> under Enterprise Manager (I had 2 other people check the steps out too and
> they couldn't find it either).
> Did I do something wrong? Should there be ';' between the parameters or
> not?
> Thanks in advance!
> Kris
>
|||OK by adding in the ';' between the parameters via Config Manager I am now
getting the following message when I try to connect to the server after I
restart the instance backup.
Cannot connect to 'servername'
Login failed for user 'sa'. Reason: Server is in single user mode. Only
one administrator can connect at this time. (Microsoft SQL Server, Error:
18461)
I even went to the length to unplugg the network cable and restart with
server off the network and I still received the same error. Only database I
was moving at the time was 'Model' using the procedures of Article ID 224071.
Doing another search I found a tech net artilce telling of another want to
move all system databases other then master and resources
http://technet.microsoft.com/en-us/library/ms345408.aspx
, which is different then 224071. Any ideas and help is great!
Thanks again!
Kris
"Tibor Karaszi" wrote:

> It depend son what tool you are using. In Config Manager: Yes.
> In RegEdit: No, since each parameter has it's own key.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
> news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
>

moving system databases

Hi all.
Long story, I have a clustered SQL Server 2005 Standard Edition that is
using a SAN. We have just added more drives to our SAN and I need to move
the system database off the current drive to another drive. I have read som
e
others that have too have asked the same question. And Article ID 224071
keeps coming up. Well I just tried following this article this morning on m
y
beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
production and after I tried changing the startup parameters and tried
starting SQL server instance backup I received the following error.
FCB::Open: Operating system error 2(The system cannot find the file
specified.) occurred while creating or opening file 'F:\Program
Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
Diagnose and correct the operating system error, and retry the operation.
And after a Google search I ran across an article out on MSDN, saying that
you need to use a ';' in between the parameters.
http://msdn2.microsoft.com/en-us/library/ms190699.aspx
I had to use SQL Server Configuration Manager to change the startup
parameters because there was no 'startup parameters' under the general tab
under Enterprise Manager (I had 2 other people check the steps out too and
they couldn't find it either).
Did I do something wrong? Should there be ';' between the parameters or not
?
Thanks in advance!
KrisIf it helps, my SQL 2005 startup parameters from teh Config manager:
-dC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
Or check in the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
Server\MSSQL.1\MSSQLServer\Parameters
Kevin Hill
IC3 North Texas
www.ChristianCycling.com
Please support me in the 2008 MS150:
http://www.ms150.org/dallas/donate/donate.cfm?id=208000
"Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
> Hi all.
> Long story, I have a clustered SQL Server 2005 Standard Edition that is
> using a SAN. We have just added more drives to our SAN and I need to move
> the system database off the current drive to another drive. I have read
> some
> others that have too have asked the same question. And Article ID 224071
> keeps coming up. Well I just tried following this article this morning on
> my
> beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
> production and after I tried changing the startup parameters and tried
> starting SQL server instance backup I received the following error.
> FCB::Open: Operating system error 2(The system cannot find the file
> specified.) occurred while creating or opening file 'F:\Program
> Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
> Diagnose and correct the operating system error, and retry the operation.
> And after a Google search I ran across an article out on MSDN, saying that
> you need to use a ';' in between the parameters.
> http://msdn2.microsoft.com/en-us/library/ms190699.aspx
> I had to use SQL Server Configuration Manager to change the startup
> parameters because there was no 'startup parameters' under the general tab
> under Enterprise Manager (I had 2 other people check the steps out too and
> they couldn't find it either).
> Did I do something wrong? Should there be ';' between the parameters or
> not?
> Thanks in advance!
> Kris
>|||> Should there be ';' between the parameters or not?
It depend son what tool you are using. In Config Manager: Yes.
In RegEdit: No, since each parameter has it's own key.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
> Hi all.
> Long story, I have a clustered SQL Server 2005 Standard Edition that is
> using a SAN. We have just added more drives to our SAN and I need to move
> the system database off the current drive to another drive. I have read s
ome
> others that have too have asked the same question. And Article ID 224071
> keeps coming up. Well I just tried following this article this morning on
my
> beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
> production and after I tried changing the startup parameters and tried
> starting SQL server instance backup I received the following error.
> FCB::Open: Operating system error 2(The system cannot find the file
> specified.) occurred while creating or opening file 'F:\Program
> Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
> Diagnose and correct the operating system error, and retry the operation.
> And after a Google search I ran across an article out on MSDN, saying that
> you need to use a ';' in between the parameters.
> http://msdn2.microsoft.com/en-us/library/ms190699.aspx
> I had to use SQL Server Configuration Manager to change the startup
> parameters because there was no 'startup parameters' under the general tab
> under Enterprise Manager (I had 2 other people check the steps out too and
> they couldn't find it either).
> Did I do something wrong? Should there be ';' between the parameters or n
ot?
> Thanks in advance!
> Kris
>|||OK by adding in the ';' between the parameters via Config Manager I am now
getting the following message when I try to connect to the server after I
restart the instance backup.
Cannot connect to 'servername'
Login failed for user 'sa'. Reason: Server is in single user mode. Only
one administrator can connect at this time. (Microsoft SQL Server, Error:
18461)
I even went to the length to unplugg the network cable and restart with
server off the network and I still received the same error. Only database I
was moving at the time was 'Model' using the procedures of Article ID 224071
.
Doing another search I found a tech net artilce telling of another want to
move all system databases other then master and resources
http://technet.microsoft.com/en-us/...y/ms345408.aspx
, which is different then 224071. Any ideas and help is great!
Thanks again!
Kris
"Tibor Karaszi" wrote:

> It depend son what tool you are using. In Config Manager: Yes.
> In RegEdit: No, since each parameter has it's own key.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
> news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
>

moving system databases

Hi all.
Long story, I have a clustered SQL Server 2005 Standard Edition that is
using a SAN. We have just added more drives to our SAN and I need to move
the system database off the current drive to another drive. I have read some
others that have too have asked the same question. And Article ID 224071
keeps coming up. Well I just tried following this article this morning on my
beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
production and after I tried changing the startup parameters and tried
starting SQL server instance backup I received the following error.
FCB::Open: Operating system error 2(The system cannot find the file
specified.) occurred while creating or opening file 'F:\Program
Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
Diagnose and correct the operating system error, and retry the operation.
And after a Google search I ran across an article out on MSDN, saying that
you need to use a ';' in between the parameters.
http://msdn2.microsoft.com/en-us/library/ms190699.aspx
I had to use SQL Server Configuration Manager to change the startup
parameters because there was no 'startup parameters' under the general tab
under Enterprise Manager (I had 2 other people check the steps out too and
they couldn't find it either).
Did I do something wrong? Should there be ';' between the parameters or not?
Thanks in advance!
KrisIf it helps, my SQL 2005 startup parameters from teh Config manager:
-dC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
Or check in the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.1\MSSQLServer\Parameters
--
Kevin Hill
IC3 North Texas
www.ChristianCycling.com
Please support me in the 2008 MS150:
http://www.ms150.org/dallas/donate/donate.cfm?id=208000
"Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
> Hi all.
> Long story, I have a clustered SQL Server 2005 Standard Edition that is
> using a SAN. We have just added more drives to our SAN and I need to move
> the system database off the current drive to another drive. I have read
> some
> others that have too have asked the same question. And Article ID 224071
> keeps coming up. Well I just tried following this article this morning on
> my
> beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
> production and after I tried changing the startup parameters and tried
> starting SQL server instance backup I received the following error.
> FCB::Open: Operating system error 2(The system cannot find the file
> specified.) occurred while creating or opening file 'F:\Program
> Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
> Diagnose and correct the operating system error, and retry the operation.
> And after a Google search I ran across an article out on MSDN, saying that
> you need to use a ';' in between the parameters.
> http://msdn2.microsoft.com/en-us/library/ms190699.aspx
> I had to use SQL Server Configuration Manager to change the startup
> parameters because there was no 'startup parameters' under the general tab
> under Enterprise Manager (I had 2 other people check the steps out too and
> they couldn't find it either).
> Did I do something wrong? Should there be ';' between the parameters or
> not?
> Thanks in advance!
> Kris
>|||> Should there be ';' between the parameters or not?
It depend son what tool you are using. In Config Manager: Yes.
In RegEdit: No, since each parameter has it's own key.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
> Hi all.
> Long story, I have a clustered SQL Server 2005 Standard Edition that is
> using a SAN. We have just added more drives to our SAN and I need to move
> the system database off the current drive to another drive. I have read some
> others that have too have asked the same question. And Article ID 224071
> keeps coming up. Well I just tried following this article this morning on my
> beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
> production and after I tried changing the startup parameters and tried
> starting SQL server instance backup I received the following error.
> FCB::Open: Operating system error 2(The system cannot find the file
> specified.) occurred while creating or opening file 'F:\Program
> Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
> Diagnose and correct the operating system error, and retry the operation.
> And after a Google search I ran across an article out on MSDN, saying that
> you need to use a ';' in between the parameters.
> http://msdn2.microsoft.com/en-us/library/ms190699.aspx
> I had to use SQL Server Configuration Manager to change the startup
> parameters because there was no 'startup parameters' under the general tab
> under Enterprise Manager (I had 2 other people check the steps out too and
> they couldn't find it either).
> Did I do something wrong? Should there be ';' between the parameters or not?
> Thanks in advance!
> Kris
>|||OK by adding in the ';' between the parameters via Config Manager I am now
getting the following message when I try to connect to the server after I
restart the instance backup.
Cannot connect to 'servername'
Login failed for user 'sa'. Reason: Server is in single user mode. Only
one administrator can connect at this time. (Microsoft SQL Server, Error:
18461)
I even went to the length to unplugg the network cable and restart with
server off the network and I still received the same error. Only database I
was moving at the time was 'Model' using the procedures of Article ID 224071.
Doing another search I found a tech net artilce telling of another want to
move all system databases other then master and resources
http://technet.microsoft.com/en-us/library/ms345408.aspx
, which is different then 224071. Any ideas and help is great!
Thanks again!
Kris
"Tibor Karaszi" wrote:
> > Should there be ';' between the parameters or not?
> It depend son what tool you are using. In Config Manager: Yes.
> In RegEdit: No, since each parameter has it's own key.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
> news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
> > Hi all.
> >
> > Long story, I have a clustered SQL Server 2005 Standard Edition that is
> > using a SAN. We have just added more drives to our SAN and I need to move
> > the system database off the current drive to another drive. I have read some
> > others that have too have asked the same question. And Article ID 224071
> > keeps coming up. Well I just tried following this article this morning on my
> > beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
> > production and after I tried changing the startup parameters and tried
> > starting SQL server instance backup I received the following error.
> >
> > FCB::Open: Operating system error 2(The system cannot find the file
> > specified.) occurred while creating or opening file 'F:\Program
> > Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
> > Diagnose and correct the operating system error, and retry the operation.
> >
> > And after a Google search I ran across an article out on MSDN, saying that
> > you need to use a ';' in between the parameters.
> > http://msdn2.microsoft.com/en-us/library/ms190699.aspx
> >
> > I had to use SQL Server Configuration Manager to change the startup
> > parameters because there was no 'startup parameters' under the general tab
> > under Enterprise Manager (I had 2 other people check the steps out too and
> > they couldn't find it either).
> >
> > Did I do something wrong? Should there be ';' between the parameters or not?
> >
> > Thanks in advance!
> > Kris
> >
>

moving SQL location

Hello,

In process of installing TFS, I unintentionally installed SQL server on C drive as I could'n see any option of selecting the drives.

Is there any way in which I can move the database folder to another drive without reformatting and going through the same procedure.

TIA

Krisna,

What version of SQL server are you running?

Yes, you can move the DB folders, although SQL server itself will want to stay on the C drive.

Note the names of your user databases, (in the properties of the databases themselves) and then drop them. Then copy/move them to the new location and re-attach.

The system databases (master. model, tempdb and msdb) are a different kettle of fish though. Instructions for moving all databases is here:

http://support.microsoft.com/kb/224071/en-us

moving sql databases to different server different location

How do I move databases currently on a cluster to a standalone machine with
different drives and location?You can use backup/restore or detach/attach. In the case of backup/restore,
you'll need to use the WITH MOVE option to specify the desired location of
the database files on the target server.
Hope this helps.
Dan Guzman
SQL Server MVP
"nobody" <nobody@.nobody.com> wrote in message
news:%23HdDWRTpHHA.3968@.TK2MSFTNGP06.phx.gbl...
> How do I move databases currently on a cluster to a standalone machine
> with different drives and location?
>|||Hi
"nobody" wrote:

> How do I move databases currently on a cluster to a standalone machine wit
h
> different drives and location?
>
As well as Dan's suggestions you could use sp_detach/sp_attach although this
would mean that your database on the cluster would be down while you copied
the files. See http://support.microsoft.com/kb/314546 also note the part
about orphaned users.
John|||how do you use the move option? I am using the gui and it does not give you
an option
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:8A59927E-2DD6-432F-8348-E32E2FC0A130@.microsoft.com...
> You can use backup/restore or detach/attach. In the case of
> backup/restore, you'll need to use the WITH MOVE option to specify the
> desired location of the database files on the target server.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23HdDWRTpHHA.3968@.TK2MSFTNGP06.phx.gbl...
>|||Hi
"nobody" wrote:

> how do you use the move option? I am using the gui and it does not give yo
u
> an option
The move options when using Enterprise Manager are on the option tab of the
restore dialog. For a T-SQL example look at example E of the Restore topic i
n
books online or at
http://msdn2.microsoft.com/en-us/library/aa238405(SQL.80).aspx, if the
database already exist on the desitination server, then you may need to add
the REPLACE option. If you are going to do this more than once then having a
script to do it will be easier.
John

moving sql databases to different server different location

How do I move databases currently on a cluster to a standalone machine with
different drives and location?
You can use backup/restore or detach/attach. In the case of backup/restore,
you'll need to use the WITH MOVE option to specify the desired location of
the database files on the target server.
Hope this helps.
Dan Guzman
SQL Server MVP
"nobody" <nobody@.nobody.com> wrote in message
news:%23HdDWRTpHHA.3968@.TK2MSFTNGP06.phx.gbl...
> How do I move databases currently on a cluster to a standalone machine
> with different drives and location?
>
|||how do you use the move option? I am using the gui and it does not give you
an option
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:8A59927E-2DD6-432F-8348-E32E2FC0A130@.microsoft.com...
> You can use backup/restore or detach/attach. In the case of
> backup/restore, you'll need to use the WITH MOVE option to specify the
> desired location of the database files on the target server.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23HdDWRTpHHA.3968@.TK2MSFTNGP06.phx.gbl...
>
|||Hi
"nobody" wrote:

> how do you use the move option? I am using the gui and it does not give you
> an option
The move options when using Enterprise Manager are on the option tab of the
restore dialog. For a T-SQL example look at example E of the Restore topic in
books online or at
http://msdn2.microsoft.com/en-us/library/aa238405(SQL.80).aspx, if the
database already exist on the desitination server, then you may need to add
the REPLACE option. If you are going to do this more than once then having a
script to do it will be easier.
John

moving sql databases to different server different location

How do I move databases currently on a cluster to a standalone machine with
different drives and location?You can use backup/restore or detach/attach. In the case of backup/restore,
you'll need to use the WITH MOVE option to specify the desired location of
the database files on the target server.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"nobody" <nobody@.nobody.com> wrote in message
news:%23HdDWRTpHHA.3968@.TK2MSFTNGP06.phx.gbl...
> How do I move databases currently on a cluster to a standalone machine
> with different drives and location?
>|||Hi
"nobody" wrote:
> How do I move databases currently on a cluster to a standalone machine with
> different drives and location?
>
As well as Dan's suggestions you could use sp_detach/sp_attach although this
would mean that your database on the cluster would be down while you copied
the files. See http://support.microsoft.com/kb/314546 also note the part
about orphaned users.
John|||how do you use the move option? I am using the gui and it does not give you
an option
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:8A59927E-2DD6-432F-8348-E32E2FC0A130@.microsoft.com...
> You can use backup/restore or detach/attach. In the case of
> backup/restore, you'll need to use the WITH MOVE option to specify the
> desired location of the database files on the target server.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23HdDWRTpHHA.3968@.TK2MSFTNGP06.phx.gbl...
>> How do I move databases currently on a cluster to a standalone machine
>> with different drives and location?
>|||Hi
"nobody" wrote:
> how do you use the move option? I am using the gui and it does not give you
> an option
The move options when using Enterprise Manager are on the option tab of the
restore dialog. For a T-SQL example look at example E of the Restore topic in
books online or at
http://msdn2.microsoft.com/en-us/library/aa238405(SQL.80).aspx, if the
database already exist on the desitination server, then you may need to add
the REPLACE option. If you are going to do this more than once then having a
script to do it will be easier.
John

Moving resources to SATA storage temporarily

We are planning to move all resources to some SATA drives so we can
reconfigure the SAN. This includes the Quorum and all data resources.
Does anyone have any advice or can anyone think of any "gotchas" that we
should be watching for or preparing for?
This is unsupported and won't work. SCSI, SAN's, and iSCSI are supported. If
you SAN can handle SATA drives, go for it!
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Wayne" <watkinson@.sd43.bc.ca> wrote in message
news:eDrXTar$GHA.3308@.TK2MSFTNGP03.phx.gbl...
> We are planning to move all resources to some SATA drives so we can
> reconfigure the SAN. This includes the Quorum and all data resources.
> Does anyone have any advice or can anyone think of any "gotchas" that we
> should be watching for or preparing for?
>
|||"Wayne" <watkinson@.sd43.bc.ca> wrote in message
news:eDrXTar$GHA.3308@.TK2MSFTNGP03.phx.gbl...
> We are planning to move all resources to some SATA drives so we can
> reconfigure the SAN. This includes the Quorum and all data resources.
> Does anyone have any advice or can anyone think of any "gotchas" that we
> should be watching for or preparing for?
As Rodney said, SATA won't cut it.
Something you might consider would be to utilize a Majority Node Set quorum
so that way you can at least start with a reconfiguration of the quorum
disk.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp