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
>
>
>
>
Showing posts with label unit. Show all posts
Showing posts with label unit. Show all posts
Friday, March 23, 2012
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
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
>
>
>
>
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
>
>
>
>
Subscribe to:
Posts (Atom)