dbTalk Databases Forums  

moving from one San to another

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss moving from one San to another in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
MattRidd
 
Posts: n/a

Default moving from one San to another - 08-08-2008 , 03:10 AM






Hello,

We are about to migrate from one storage system to another & the biggest
stumbling block we have at the moment is how to migrate our SQL 2005 64bit
data.

I found a tool for being able to migrate the data on exchange, but have not
found one for SQL 2005 64 bit.
Is there a tool that will help me migrate?

Many Thanks,
Matt Riddler

Reply With Quote
  #2  
Old   
Linchi Shea
 
Posts: n/a

Default RE: moving from one San to another - 08-09-2008 , 03:57 PM






If you have a small amount of data, you can migrate the data using the
typical BACKUP\RESTORE or detach\attach approach, just as you would in a
non-SAN environment.

If you have a large amount of data, you may be better working with the
storage folks and asking them to move (or copy) the file to the destination
server. They can easily move the data to a different server, and as long as
everything is laid out at the OS level as the original server, and you
install SQL Server to the same location, this can be a rather quick way to
migrate.

Linchi

"MattRidd" wrote:

Quote:
Hello,

We are about to migrate from one storage system to another & the biggest
stumbling block we have at the moment is how to migrate our SQL 2005 64bit
data.

I found a tool for being able to migrate the data on exchange, but have not
found one for SQL 2005 64 bit.
Is there a tool that will help me migrate?

Many Thanks,
Matt Riddler

Reply With Quote
  #3  
Old   
Linchi Shea
 
Posts: n/a

Default RE: moving from one San to another - 08-09-2008 , 03:57 PM



If you have a small amount of data, you can migrate the data using the
typical BACKUP\RESTORE or detach\attach approach, just as you would in a
non-SAN environment.

If you have a large amount of data, you may be better working with the
storage folks and asking them to move (or copy) the file to the destination
server. They can easily move the data to a different server, and as long as
everything is laid out at the OS level as the original server, and you
install SQL Server to the same location, this can be a rather quick way to
migrate.

Linchi

"MattRidd" wrote:

Quote:
Hello,

We are about to migrate from one storage system to another & the biggest
stumbling block we have at the moment is how to migrate our SQL 2005 64bit
data.

I found a tool for being able to migrate the data on exchange, but have not
found one for SQL 2005 64 bit.
Is there a tool that will help me migrate?

Many Thanks,
Matt Riddler

Reply With Quote
  #4  
Old   
Linchi Shea
 
Posts: n/a

Default RE: moving from one San to another - 08-09-2008 , 03:57 PM



If you have a small amount of data, you can migrate the data using the
typical BACKUP\RESTORE or detach\attach approach, just as you would in a
non-SAN environment.

If you have a large amount of data, you may be better working with the
storage folks and asking them to move (or copy) the file to the destination
server. They can easily move the data to a different server, and as long as
everything is laid out at the OS level as the original server, and you
install SQL Server to the same location, this can be a rather quick way to
migrate.

Linchi

"MattRidd" wrote:

Quote:
Hello,

We are about to migrate from one storage system to another & the biggest
stumbling block we have at the moment is how to migrate our SQL 2005 64bit
data.

I found a tool for being able to migrate the data on exchange, but have not
found one for SQL 2005 64 bit.
Is there a tool that will help me migrate?

Many Thanks,
Matt Riddler

Reply With Quote
  #5  
Old   
Linchi Shea
 
Posts: n/a

Default RE: moving from one San to another - 08-09-2008 , 03:57 PM



If you have a small amount of data, you can migrate the data using the
typical BACKUP\RESTORE or detach\attach approach, just as you would in a
non-SAN environment.

If you have a large amount of data, you may be better working with the
storage folks and asking them to move (or copy) the file to the destination
server. They can easily move the data to a different server, and as long as
everything is laid out at the OS level as the original server, and you
install SQL Server to the same location, this can be a rather quick way to
migrate.

Linchi

"MattRidd" wrote:

Quote:
Hello,

We are about to migrate from one storage system to another & the biggest
stumbling block we have at the moment is how to migrate our SQL 2005 64bit
data.

I found a tool for being able to migrate the data on exchange, but have not
found one for SQL 2005 64 bit.
Is there a tool that will help me migrate?

Many Thanks,
Matt Riddler

Reply With Quote
  #6  
Old   
Linchi Shea
 
Posts: n/a

Default RE: moving from one San to another - 08-09-2008 , 03:57 PM



If you have a small amount of data, you can migrate the data using the
typical BACKUP\RESTORE or detach\attach approach, just as you would in a
non-SAN environment.

If you have a large amount of data, you may be better working with the
storage folks and asking them to move (or copy) the file to the destination
server. They can easily move the data to a different server, and as long as
everything is laid out at the OS level as the original server, and you
install SQL Server to the same location, this can be a rather quick way to
migrate.

Linchi

"MattRidd" wrote:

Quote:
Hello,

We are about to migrate from one storage system to another & the biggest
stumbling block we have at the moment is how to migrate our SQL 2005 64bit
data.

I found a tool for being able to migrate the data on exchange, but have not
found one for SQL 2005 64 bit.
Is there a tool that will help me migrate?

Many Thanks,
Matt Riddler

Reply With Quote
  #7  
Old   
Linchi Shea
 
Posts: n/a

Default RE: moving from one San to another - 08-09-2008 , 03:57 PM



If you have a small amount of data, you can migrate the data using the
typical BACKUP\RESTORE or detach\attach approach, just as you would in a
non-SAN environment.

If you have a large amount of data, you may be better working with the
storage folks and asking them to move (or copy) the file to the destination
server. They can easily move the data to a different server, and as long as
everything is laid out at the OS level as the original server, and you
install SQL Server to the same location, this can be a rather quick way to
migrate.

Linchi

"MattRidd" wrote:

Quote:
Hello,

We are about to migrate from one storage system to another & the biggest
stumbling block we have at the moment is how to migrate our SQL 2005 64bit
data.

I found a tool for being able to migrate the data on exchange, but have not
found one for SQL 2005 64 bit.
Is there a tool that will help me migrate?

Many Thanks,
Matt Riddler

Reply With Quote
  #8  
Old   
Linchi Shea
 
Posts: n/a

Default RE: moving from one San to another - 08-09-2008 , 03:57 PM



If you have a small amount of data, you can migrate the data using the
typical BACKUP\RESTORE or detach\attach approach, just as you would in a
non-SAN environment.

If you have a large amount of data, you may be better working with the
storage folks and asking them to move (or copy) the file to the destination
server. They can easily move the data to a different server, and as long as
everything is laid out at the OS level as the original server, and you
install SQL Server to the same location, this can be a rather quick way to
migrate.

Linchi

"MattRidd" wrote:

Quote:
Hello,

We are about to migrate from one storage system to another & the biggest
stumbling block we have at the moment is how to migrate our SQL 2005 64bit
data.

I found a tool for being able to migrate the data on exchange, but have not
found one for SQL 2005 64 bit.
Is there a tool that will help me migrate?

Many Thanks,
Matt Riddler

Reply With Quote
  #9  
Old   
Linchi Shea
 
Posts: n/a

Default RE: moving from one San to another - 08-09-2008 , 03:57 PM



If you have a small amount of data, you can migrate the data using the
typical BACKUP\RESTORE or detach\attach approach, just as you would in a
non-SAN environment.

If you have a large amount of data, you may be better working with the
storage folks and asking them to move (or copy) the file to the destination
server. They can easily move the data to a different server, and as long as
everything is laid out at the OS level as the original server, and you
install SQL Server to the same location, this can be a rather quick way to
migrate.

Linchi

"MattRidd" wrote:

Quote:
Hello,

We are about to migrate from one storage system to another & the biggest
stumbling block we have at the moment is how to migrate our SQL 2005 64bit
data.

I found a tool for being able to migrate the data on exchange, but have not
found one for SQL 2005 64 bit.
Is there a tool that will help me migrate?

Many Thanks,
Matt Riddler

Reply With Quote
  #10  
Old   
Linchi Shea
 
Posts: n/a

Default RE: moving from one San to another - 08-09-2008 , 03:57 PM



If you have a small amount of data, you can migrate the data using the
typical BACKUP\RESTORE or detach\attach approach, just as you would in a
non-SAN environment.

If you have a large amount of data, you may be better working with the
storage folks and asking them to move (or copy) the file to the destination
server. They can easily move the data to a different server, and as long as
everything is laid out at the OS level as the original server, and you
install SQL Server to the same location, this can be a rather quick way to
migrate.

Linchi

"MattRidd" wrote:

Quote:
Hello,

We are about to migrate from one storage system to another & the biggest
stumbling block we have at the moment is how to migrate our SQL 2005 64bit
data.

I found a tool for being able to migrate the data on exchange, but have not
found one for SQL 2005 64 bit.
Is there a tool that will help me migrate?

Many Thanks,
Matt Riddler

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.