Hi I have an instance of sql2005 on my machine and connected to a sql2000
server. I tried using the export wizard to create a package with the source
being tables from a database on the 2000 server and the destination being an
excel file on my machine. I also selected save package on the 2005 server.
When executing it makes it to the save portion but I then get the error, Save
to SQL Server failed, no description found!
Thanks.
--
Paul G
Software engineer.Hi Paul,
Please ensure that the user account in SQL who runs the job has adequate
privileges.
"Paul" wrote:
> Hi I have an instance of sql2005 on my machine and connected to a sql2000
> server. I tried using the export wizard to create a package with the source
> being tables from a database on the 2000 server and the destination being an
> excel file on my machine. I also selected save package on the 2005 server.
> When executing it makes it to the save portion but I then get the error, Save
> to SQL Server failed, no description found!
> Thanks.
> --
> Paul G
> Software engineer.|||ok I think that may have been the problem. Also I changed the authentication
from windows to mixed mode so will give it a try.
--
Paul G
Software engineer.
"Amol Lembhe" wrote:
> Hi Paul,
> Please ensure that the user account in SQL who runs the job has adequate
> privileges.
> "Paul" wrote:
> > Hi I have an instance of sql2005 on my machine and connected to a sql2000
> > server. I tried using the export wizard to create a package with the source
> > being tables from a database on the 2000 server and the destination being an
> > excel file on my machine. I also selected save package on the 2005 server.
> > When executing it makes it to the save portion but I then get the error, Save
> > to SQL Server failed, no description found!
> > Thanks.
> > --
> > Paul G
> > Software engineer.
Showing posts with label instance. Show all posts
Showing posts with label instance. Show all posts
Monday, March 12, 2012
Wednesday, March 7, 2012
SAN Remote Mirroring
I am researching if it is possible to remote mirror an entire instance of SQL
Server on a SAN? Specfically, we would like to install SQL Server program
files, data files and log files on SAN drives and then syncronously mirror
those to a remote SAN. The only articles I have found deal with doing a
split-mirror of a user database but still having to maintain logins, DTS
packages, etc. manually by recreating them on the remote side. The only
other info I have is that we also have DB2 and have been told by IBM that a
partial page write could occur so they don't recommend mirroring data but
since the log can deal with a partial page write that it would be possible to
mirror the log files. But, on the other side there would still have to
something setup to apply those logs.
--
bscgmccYou also should look at SQL Server Database Mirroring.
Ben Nevarez, MCDBA, OCP
Database Administrator
"bsc gmcc" wrote:
> I am researching if it is possible to remote mirror an entire instance of SQL
> Server on a SAN? Specfically, we would like to install SQL Server program
> files, data files and log files on SAN drives and then syncronously mirror
> those to a remote SAN. The only articles I have found deal with doing a
> split-mirror of a user database but still having to maintain logins, DTS
> packages, etc. manually by recreating them on the remote side. The only
> other info I have is that we also have DB2 and have been told by IBM that a
> partial page write could occur so they don't recommend mirroring data but
> since the log can deal with a partial page write that it would be possible to
> mirror the log files. But, on the other side there would still have to
> something setup to apply those logs.
> --
> bscgmcc|||The problem with replication, log shipping, database mirroring, etc. is that
it is at a database level. I need something to protect my entire instance
including master, model and msdb.
--
bscgmcc
"Ben Nevarez" wrote:
> You also should look at SQL Server Database Mirroring.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "bsc gmcc" wrote:
> > I am researching if it is possible to remote mirror an entire instance of SQL
> > Server on a SAN? Specfically, we would like to install SQL Server program
> > files, data files and log files on SAN drives and then syncronously mirror
> > those to a remote SAN. The only articles I have found deal with doing a
> > split-mirror of a user database but still having to maintain logins, DTS
> > packages, etc. manually by recreating them on the remote side. The only
> > other info I have is that we also have DB2 and have been told by IBM that a
> > partial page write could occur so they don't recommend mirroring data but
> > since the log can deal with a partial page write that it would be possible to
> > mirror the log files. But, on the other side there would still have to
> > something setup to apply those logs.
> > --
> > bscgmcc|||What I would do is just make sure that the SAN hardware vendor and/or
Microsoft certify that this SAN remote mirror solution will work with SQL
Server.
By the way, by using Database Mirroring you do not have to worry (much)
about the original master and msdb databases. You just need to do the same
configuration (like logins, linked servers, jobs, etc.) in both servers.
Ben Nevarez, MCDBA, OCP
Database Administrator
"bsc gmcc" wrote:
> The problem with replication, log shipping, database mirroring, etc. is that
> it is at a database level. I need something to protect my entire instance
> including master, model and msdb.
> --
> bscgmcc
>
> "Ben Nevarez" wrote:
> >
> > You also should look at SQL Server Database Mirroring.
> >
> > Ben Nevarez, MCDBA, OCP
> > Database Administrator
> >
> >
> > "bsc gmcc" wrote:
> >
> > > I am researching if it is possible to remote mirror an entire instance of SQL
> > > Server on a SAN? Specfically, we would like to install SQL Server program
> > > files, data files and log files on SAN drives and then syncronously mirror
> > > those to a remote SAN. The only articles I have found deal with doing a
> > > split-mirror of a user database but still having to maintain logins, DTS
> > > packages, etc. manually by recreating them on the remote side. The only
> > > other info I have is that we also have DB2 and have been told by IBM that a
> > > partial page write could occur so they don't recommend mirroring data but
> > > since the log can deal with a partial page write that it would be possible to
> > > mirror the log files. But, on the other side there would still have to
> > > something setup to apply those logs.
> > > --
> > > bscgmcc|||Hi
I assume you are talking about SAN replication to a passive server? In which
case if you mirror your system database you should not need to maintain your
SQL logins or DTS packages held in msdb or on a replicated disc. If your
remote machine is on the same domain then Windows Authentication should be
fine.
John
"bsc gmcc" wrote:
> I am researching if it is possible to remote mirror an entire instance of SQL
> Server on a SAN? Specfically, we would like to install SQL Server program
> files, data files and log files on SAN drives and then syncronously mirror
> those to a remote SAN. The only articles I have found deal with doing a
> split-mirror of a user database but still having to maintain logins, DTS
> packages, etc. manually by recreating them on the remote side. The only
> other info I have is that we also have DB2 and have been told by IBM that a
> partial page write could occur so they don't recommend mirroring data but
> since the log can deal with a partial page write that it would be possible to
> mirror the log files. But, on the other side there would still have to
> something setup to apply those logs.
> --
> bscgmcc|||Is the remote instance of SQL going to be running.
There are a few ways it can be done to mirror the data. A software solution provided by your SAN manufacturer to snap the data and move it across the fabric to your remote san at a hardware level.
A software solution, using VSS can snap and move across fabric/network via a third party, such as backup provider. I use something similar to this method currently. (I do it on all the DB's incl model, master, temp, and logs, but no program files, although there is software that can).
With 2005 SP1 database mirroring is also a possible solution, but would not mirror program files, etc.
Server on a SAN? Specfically, we would like to install SQL Server program
files, data files and log files on SAN drives and then syncronously mirror
those to a remote SAN. The only articles I have found deal with doing a
split-mirror of a user database but still having to maintain logins, DTS
packages, etc. manually by recreating them on the remote side. The only
other info I have is that we also have DB2 and have been told by IBM that a
partial page write could occur so they don't recommend mirroring data but
since the log can deal with a partial page write that it would be possible to
mirror the log files. But, on the other side there would still have to
something setup to apply those logs.
--
bscgmccYou also should look at SQL Server Database Mirroring.
Ben Nevarez, MCDBA, OCP
Database Administrator
"bsc gmcc" wrote:
> I am researching if it is possible to remote mirror an entire instance of SQL
> Server on a SAN? Specfically, we would like to install SQL Server program
> files, data files and log files on SAN drives and then syncronously mirror
> those to a remote SAN. The only articles I have found deal with doing a
> split-mirror of a user database but still having to maintain logins, DTS
> packages, etc. manually by recreating them on the remote side. The only
> other info I have is that we also have DB2 and have been told by IBM that a
> partial page write could occur so they don't recommend mirroring data but
> since the log can deal with a partial page write that it would be possible to
> mirror the log files. But, on the other side there would still have to
> something setup to apply those logs.
> --
> bscgmcc|||The problem with replication, log shipping, database mirroring, etc. is that
it is at a database level. I need something to protect my entire instance
including master, model and msdb.
--
bscgmcc
"Ben Nevarez" wrote:
> You also should look at SQL Server Database Mirroring.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "bsc gmcc" wrote:
> > I am researching if it is possible to remote mirror an entire instance of SQL
> > Server on a SAN? Specfically, we would like to install SQL Server program
> > files, data files and log files on SAN drives and then syncronously mirror
> > those to a remote SAN. The only articles I have found deal with doing a
> > split-mirror of a user database but still having to maintain logins, DTS
> > packages, etc. manually by recreating them on the remote side. The only
> > other info I have is that we also have DB2 and have been told by IBM that a
> > partial page write could occur so they don't recommend mirroring data but
> > since the log can deal with a partial page write that it would be possible to
> > mirror the log files. But, on the other side there would still have to
> > something setup to apply those logs.
> > --
> > bscgmcc|||What I would do is just make sure that the SAN hardware vendor and/or
Microsoft certify that this SAN remote mirror solution will work with SQL
Server.
By the way, by using Database Mirroring you do not have to worry (much)
about the original master and msdb databases. You just need to do the same
configuration (like logins, linked servers, jobs, etc.) in both servers.
Ben Nevarez, MCDBA, OCP
Database Administrator
"bsc gmcc" wrote:
> The problem with replication, log shipping, database mirroring, etc. is that
> it is at a database level. I need something to protect my entire instance
> including master, model and msdb.
> --
> bscgmcc
>
> "Ben Nevarez" wrote:
> >
> > You also should look at SQL Server Database Mirroring.
> >
> > Ben Nevarez, MCDBA, OCP
> > Database Administrator
> >
> >
> > "bsc gmcc" wrote:
> >
> > > I am researching if it is possible to remote mirror an entire instance of SQL
> > > Server on a SAN? Specfically, we would like to install SQL Server program
> > > files, data files and log files on SAN drives and then syncronously mirror
> > > those to a remote SAN. The only articles I have found deal with doing a
> > > split-mirror of a user database but still having to maintain logins, DTS
> > > packages, etc. manually by recreating them on the remote side. The only
> > > other info I have is that we also have DB2 and have been told by IBM that a
> > > partial page write could occur so they don't recommend mirroring data but
> > > since the log can deal with a partial page write that it would be possible to
> > > mirror the log files. But, on the other side there would still have to
> > > something setup to apply those logs.
> > > --
> > > bscgmcc|||Hi
I assume you are talking about SAN replication to a passive server? In which
case if you mirror your system database you should not need to maintain your
SQL logins or DTS packages held in msdb or on a replicated disc. If your
remote machine is on the same domain then Windows Authentication should be
fine.
John
"bsc gmcc" wrote:
> I am researching if it is possible to remote mirror an entire instance of SQL
> Server on a SAN? Specfically, we would like to install SQL Server program
> files, data files and log files on SAN drives and then syncronously mirror
> those to a remote SAN. The only articles I have found deal with doing a
> split-mirror of a user database but still having to maintain logins, DTS
> packages, etc. manually by recreating them on the remote side. The only
> other info I have is that we also have DB2 and have been told by IBM that a
> partial page write could occur so they don't recommend mirroring data but
> since the log can deal with a partial page write that it would be possible to
> mirror the log files. But, on the other side there would still have to
> something setup to apply those logs.
> --
> bscgmcc|||Is the remote instance of SQL going to be running.
There are a few ways it can be done to mirror the data. A software solution provided by your SAN manufacturer to snap the data and move it across the fabric to your remote san at a hardware level.
A software solution, using VSS can snap and move across fabric/network via a third party, such as backup provider. I use something similar to this method currently. (I do it on all the DB's incl model, master, temp, and logs, but no program files, although there is software that can).
With 2005 SP1 database mirroring is also a possible solution, but would not mirror program files, etc.
SAN Remote Mirroring
I am researching if it is possible to remote mirror an entire instance of SQ
L
Server on a SAN? Specfically, we would like to install SQL Server program
files, data files and log files on SAN drives and then syncronously mirror
those to a remote SAN. The only articles I have found deal with doing a
split-mirror of a user database but still having to maintain logins, DTS
packages, etc. manually by recreating them on the remote side. The only
other info I have is that we also have DB2 and have been told by IBM that a
partial page write could occur so they don't recommend mirroring data but
since the log can deal with a partial page write that it would be possible t
o
mirror the log files. But, on the other side there would still have to
something setup to apply those logs.
--
bscgmccYou also should look at SQL Server Database Mirroring.
Ben Nevarez, MCDBA, OCP
Database Administrator
"bsc gmcc" wrote:
> I am researching if it is possible to remote mirror an entire instance of
SQL
> Server on a SAN? Specfically, we would like to install SQL Server program
> files, data files and log files on SAN drives and then syncronously mirror
> those to a remote SAN. The only articles I have found deal with doing a
> split-mirror of a user database but still having to maintain logins, DTS
> packages, etc. manually by recreating them on the remote side. The only
> other info I have is that we also have DB2 and have been told by IBM that
a
> partial page write could occur so they don't recommend mirroring data but
> since the log can deal with a partial page write that it would be possible
to
> mirror the log files. But, on the other side there would still have to
> something setup to apply those logs.
> --
> bscgmcc|||The problem with replication, log shipping, database mirroring, etc. is that
it is at a database level. I need something to protect my entire instance
including master, model and msdb.
bscgmcc
"Ben Nevarez" wrote:
[vbcol=seagreen]
> You also should look at SQL Server Database Mirroring.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "bsc gmcc" wrote:
>|||What I would do is just make sure that the SAN hardware vendor and/or
Microsoft certify that this SAN remote mirror solution will work with SQL
Server.
By the way, by using Database Mirroring you do not have to worry (much)
about the original master and msdb databases. You just need to do the same
configuration (like logins, linked servers, jobs, etc.) in both servers.
Ben Nevarez, MCDBA, OCP
Database Administrator
"bsc gmcc" wrote:
[vbcol=seagreen]
> The problem with replication, log shipping, database mirroring, etc. is th
at
> it is at a database level. I need something to protect my entire instance
> including master, model and msdb.
> --
> bscgmcc
>
> "Ben Nevarez" wrote:
>|||Hi
I assume you are talking about SAN replication to a passive server? In which
case if you mirror your system database you should not need to maintain your
SQL logins or DTS packages held in msdb or on a replicated disc. If your
remote machine is on the same domain then Windows Authentication should be
fine.
John
"bsc gmcc" wrote:
> I am researching if it is possible to remote mirror an entire instance of
SQL
> Server on a SAN? Specfically, we would like to install SQL Server program
> files, data files and log files on SAN drives and then syncronously mirror
> those to a remote SAN. The only articles I have found deal with doing a
> split-mirror of a user database but still having to maintain logins, DTS
> packages, etc. manually by recreating them on the remote side. The only
> other info I have is that we also have DB2 and have been told by IBM that
a
> partial page write could occur so they don't recommend mirroring data but
> since the log can deal with a partial page write that it would be possible
to
> mirror the log files. But, on the other side there would still have to
> something setup to apply those logs.
> --
> bscgmcc|||Is the remote instance of SQL going to be running.
There are a few ways it can be done to mirror the data. A software solution
provided by your SAN manufacturer to snap the data and move it across the f
abric to your remote san at a hardware level.
A software solution, using VSS can snap and move across fabric/network via a
third party, such as backup provider. I use something similar to this meth
od currently. (I do it on all the DB's incl model, master, temp, and logs, b
ut no program files, althou
gh there is software that can).
With 2005 SP1 database mirroring is also a possible solution, but would not
mirror program files, etc.
L
Server on a SAN? Specfically, we would like to install SQL Server program
files, data files and log files on SAN drives and then syncronously mirror
those to a remote SAN. The only articles I have found deal with doing a
split-mirror of a user database but still having to maintain logins, DTS
packages, etc. manually by recreating them on the remote side. The only
other info I have is that we also have DB2 and have been told by IBM that a
partial page write could occur so they don't recommend mirroring data but
since the log can deal with a partial page write that it would be possible t
o
mirror the log files. But, on the other side there would still have to
something setup to apply those logs.
--
bscgmccYou also should look at SQL Server Database Mirroring.
Ben Nevarez, MCDBA, OCP
Database Administrator
"bsc gmcc" wrote:
> I am researching if it is possible to remote mirror an entire instance of
SQL
> Server on a SAN? Specfically, we would like to install SQL Server program
> files, data files and log files on SAN drives and then syncronously mirror
> those to a remote SAN. The only articles I have found deal with doing a
> split-mirror of a user database but still having to maintain logins, DTS
> packages, etc. manually by recreating them on the remote side. The only
> other info I have is that we also have DB2 and have been told by IBM that
a
> partial page write could occur so they don't recommend mirroring data but
> since the log can deal with a partial page write that it would be possible
to
> mirror the log files. But, on the other side there would still have to
> something setup to apply those logs.
> --
> bscgmcc|||The problem with replication, log shipping, database mirroring, etc. is that
it is at a database level. I need something to protect my entire instance
including master, model and msdb.
bscgmcc
"Ben Nevarez" wrote:
[vbcol=seagreen]
> You also should look at SQL Server Database Mirroring.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "bsc gmcc" wrote:
>|||What I would do is just make sure that the SAN hardware vendor and/or
Microsoft certify that this SAN remote mirror solution will work with SQL
Server.
By the way, by using Database Mirroring you do not have to worry (much)
about the original master and msdb databases. You just need to do the same
configuration (like logins, linked servers, jobs, etc.) in both servers.
Ben Nevarez, MCDBA, OCP
Database Administrator
"bsc gmcc" wrote:
[vbcol=seagreen]
> The problem with replication, log shipping, database mirroring, etc. is th
at
> it is at a database level. I need something to protect my entire instance
> including master, model and msdb.
> --
> bscgmcc
>
> "Ben Nevarez" wrote:
>|||Hi
I assume you are talking about SAN replication to a passive server? In which
case if you mirror your system database you should not need to maintain your
SQL logins or DTS packages held in msdb or on a replicated disc. If your
remote machine is on the same domain then Windows Authentication should be
fine.
John
"bsc gmcc" wrote:
> I am researching if it is possible to remote mirror an entire instance of
SQL
> Server on a SAN? Specfically, we would like to install SQL Server program
> files, data files and log files on SAN drives and then syncronously mirror
> those to a remote SAN. The only articles I have found deal with doing a
> split-mirror of a user database but still having to maintain logins, DTS
> packages, etc. manually by recreating them on the remote side. The only
> other info I have is that we also have DB2 and have been told by IBM that
a
> partial page write could occur so they don't recommend mirroring data but
> since the log can deal with a partial page write that it would be possible
to
> mirror the log files. But, on the other side there would still have to
> something setup to apply those logs.
> --
> bscgmcc|||Is the remote instance of SQL going to be running.
There are a few ways it can be done to mirror the data. A software solution
provided by your SAN manufacturer to snap the data and move it across the f
abric to your remote san at a hardware level.
A software solution, using VSS can snap and move across fabric/network via a
third party, such as backup provider. I use something similar to this meth
od currently. (I do it on all the DB's incl model, master, temp, and logs, b
ut no program files, althou
gh there is software that can).
With 2005 SP1 database mirroring is also a possible solution, but would not
mirror program files, etc.
Saturday, February 25, 2012
SAN Disk with SQL 2000 data files
Hi,
I had a small test setup with an SQL 2000 instance and its data files were
on a SAN disk. After the shutdown following an automatic Windows update
yesterday night, the SAN disk although shows up on the host and also gets
mounted, I can't "explore" it. It's actually a LUN from an EMC box so I
tried unmasking & remasking the LUN to the host, the disk shows up on the
host but I can't access it. Now I want to reformat the disk and put NTFS on
it afresh. But before that, I also want to cleanup the SQL instance and
re-install it. Just uninstalling the SQL instance will do or are there some
standard procedures that I should follow?
Thanks for any pointers!
- VHi
I would find out what the problem really it. It could be a problem with your
HBA driver or similar.
Un-installing SQL Server will not remove the data files.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Volcano" <volcano@.volcano.com> wrote in message
news:uumsjmPoFHA.3036@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I had a small test setup with an SQL 2000 instance and its data files were
> on a SAN disk. After the shutdown following an automatic Windows update
> yesterday night, the SAN disk although shows up on the host and also gets
> mounted, I can't "explore" it. It's actually a LUN from an EMC box so I
> tried unmasking & remasking the LUN to the host, the disk shows up on the
> host but I can't access it. Now I want to reformat the disk and put NTFS
> on
> it afresh. But before that, I also want to cleanup the SQL instance and
> re-install it. Just uninstalling the SQL instance will do or are there
> some
> standard procedures that I should follow?
> Thanks for any pointers!
> - V
>
I had a small test setup with an SQL 2000 instance and its data files were
on a SAN disk. After the shutdown following an automatic Windows update
yesterday night, the SAN disk although shows up on the host and also gets
mounted, I can't "explore" it. It's actually a LUN from an EMC box so I
tried unmasking & remasking the LUN to the host, the disk shows up on the
host but I can't access it. Now I want to reformat the disk and put NTFS on
it afresh. But before that, I also want to cleanup the SQL instance and
re-install it. Just uninstalling the SQL instance will do or are there some
standard procedures that I should follow?
Thanks for any pointers!
- VHi
I would find out what the problem really it. It could be a problem with your
HBA driver or similar.
Un-installing SQL Server will not remove the data files.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Volcano" <volcano@.volcano.com> wrote in message
news:uumsjmPoFHA.3036@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I had a small test setup with an SQL 2000 instance and its data files were
> on a SAN disk. After the shutdown following an automatic Windows update
> yesterday night, the SAN disk although shows up on the host and also gets
> mounted, I can't "explore" it. It's actually a LUN from an EMC box so I
> tried unmasking & remasking the LUN to the host, the disk shows up on the
> host but I can't access it. Now I want to reformat the disk and put NTFS
> on
> it afresh. But before that, I also want to cleanup the SQL instance and
> re-install it. Just uninstalling the SQL instance will do or are there
> some
> standard procedures that I should follow?
> Thanks for any pointers!
> - V
>
SAN Disk with SQL 2000 data files
Hi,
I had a small test setup with an SQL 2000 instance and its data files were
on a SAN disk. After the shutdown following an automatic Windows update
yesterday night, the SAN disk although shows up on the host and also gets
mounted, I can't "explore" it. It's actually a LUN from an EMC box so I
tried unmasking & remasking the LUN to the host, the disk shows up on the
host but I can't access it. Now I want to reformat the disk and put NTFS on
it afresh. But before that, I also want to cleanup the SQL instance and
re-install it. Just uninstalling the SQL instance will do or are there some
standard procedures that I should follow?
Thanks for any pointers!
- VHi
I would find out what the problem really it. It could be a problem with your
HBA driver or similar.
Un-installing SQL Server will not remove the data files.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Volcano" <volcano@.volcano.com> wrote in message
news:uumsjmPoFHA.3036@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I had a small test setup with an SQL 2000 instance and its data files were
> on a SAN disk. After the shutdown following an automatic Windows update
> yesterday night, the SAN disk although shows up on the host and also gets
> mounted, I can't "explore" it. It's actually a LUN from an EMC box so I
> tried unmasking & remasking the LUN to the host, the disk shows up on the
> host but I can't access it. Now I want to reformat the disk and put NTFS
> on
> it afresh. But before that, I also want to cleanup the SQL instance and
> re-install it. Just uninstalling the SQL instance will do or are there
> some
> standard procedures that I should follow?
> Thanks for any pointers!
> - V
>
I had a small test setup with an SQL 2000 instance and its data files were
on a SAN disk. After the shutdown following an automatic Windows update
yesterday night, the SAN disk although shows up on the host and also gets
mounted, I can't "explore" it. It's actually a LUN from an EMC box so I
tried unmasking & remasking the LUN to the host, the disk shows up on the
host but I can't access it. Now I want to reformat the disk and put NTFS on
it afresh. But before that, I also want to cleanup the SQL instance and
re-install it. Just uninstalling the SQL instance will do or are there some
standard procedures that I should follow?
Thanks for any pointers!
- VHi
I would find out what the problem really it. It could be a problem with your
HBA driver or similar.
Un-installing SQL Server will not remove the data files.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Volcano" <volcano@.volcano.com> wrote in message
news:uumsjmPoFHA.3036@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I had a small test setup with an SQL 2000 instance and its data files were
> on a SAN disk. After the shutdown following an automatic Windows update
> yesterday night, the SAN disk although shows up on the host and also gets
> mounted, I can't "explore" it. It's actually a LUN from an EMC box so I
> tried unmasking & remasking the LUN to the host, the disk shows up on the
> host but I can't access it. Now I want to reformat the disk and put NTFS
> on
> it afresh. But before that, I also want to cleanup the SQL instance and
> re-install it. Just uninstalling the SQL instance will do or are there
> some
> standard procedures that I should follow?
> Thanks for any pointers!
> - V
>
SAN Disk with SQL 2000 data files
Hi,
I had a small test setup with an SQL 2000 instance and its data files were
on a SAN disk. After the shutdown following an automatic Windows update
yesterday night, the SAN disk although shows up on the host and also gets
mounted, I can't "explore" it. It's actually a LUN from an EMC box so I
tried unmasking & remasking the LUN to the host, the disk shows up on the
host but I can't access it. Now I want to reformat the disk and put NTFS on
it afresh. But before that, I also want to cleanup the SQL instance and
re-install it. Just uninstalling the SQL instance will do or are there some
standard procedures that I should follow?
Thanks for any pointers!
- V
Hi
I would find out what the problem really it. It could be a problem with your
HBA driver or similar.
Un-installing SQL Server will not remove the data files.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Volcano" <volcano@.volcano.com> wrote in message
news:uumsjmPoFHA.3036@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I had a small test setup with an SQL 2000 instance and its data files were
> on a SAN disk. After the shutdown following an automatic Windows update
> yesterday night, the SAN disk although shows up on the host and also gets
> mounted, I can't "explore" it. It's actually a LUN from an EMC box so I
> tried unmasking & remasking the LUN to the host, the disk shows up on the
> host but I can't access it. Now I want to reformat the disk and put NTFS
> on
> it afresh. But before that, I also want to cleanup the SQL instance and
> re-install it. Just uninstalling the SQL instance will do or are there
> some
> standard procedures that I should follow?
> Thanks for any pointers!
> - V
>
I had a small test setup with an SQL 2000 instance and its data files were
on a SAN disk. After the shutdown following an automatic Windows update
yesterday night, the SAN disk although shows up on the host and also gets
mounted, I can't "explore" it. It's actually a LUN from an EMC box so I
tried unmasking & remasking the LUN to the host, the disk shows up on the
host but I can't access it. Now I want to reformat the disk and put NTFS on
it afresh. But before that, I also want to cleanup the SQL instance and
re-install it. Just uninstalling the SQL instance will do or are there some
standard procedures that I should follow?
Thanks for any pointers!
- V
Hi
I would find out what the problem really it. It could be a problem with your
HBA driver or similar.
Un-installing SQL Server will not remove the data files.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Volcano" <volcano@.volcano.com> wrote in message
news:uumsjmPoFHA.3036@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I had a small test setup with an SQL 2000 instance and its data files were
> on a SAN disk. After the shutdown following an automatic Windows update
> yesterday night, the SAN disk although shows up on the host and also gets
> mounted, I can't "explore" it. It's actually a LUN from an EMC box so I
> tried unmasking & remasking the LUN to the host, the disk shows up on the
> host but I can't access it. Now I want to reformat the disk and put NTFS
> on
> it afresh. But before that, I also want to cleanup the SQL instance and
> re-install it. Just uninstalling the SQL instance will do or are there
> some
> standard procedures that I should follow?
> Thanks for any pointers!
> - V
>
SAN and SQL
Hi All
We are trying to consolidate all the SQL servers (more then 250 instances).
We are considering Multi instance Sql Cluster on SAN
Is there a document/weblink that expalins the SAN systems , and
Installation/Setup of SQL Cluster on SAN.
Pro's and Con's
thanks in advance
You may find the following links helpful
Server Consolidation
====================
Planning for Consolidation with SQL Server 2000 </technet/prodtechnol/sql/2000/plan/sql2kcon.mspx>
SQL Server Consolidation on the 64-bit Platform </technet/prodtechnol/sql/2000/deploy/64bitconsolidation.mspx>
SQL Server Consolidation on the 32-bit Platform Using a Clustered Environment </technet/prodtechnol/sql/2000/deploy/32bitconsolidation.mspx>
Microsoft SQL Server 2000 Scalability ProjectServer Consolidation <http://msdn.microsoft.com/library/de...asphosting.asp>
Additional Resources
===================
http://www.microsoft.com/sql/techinf...alability.mspx
http://www.microsoft.com/sql/techinf...ilability.mspx
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest
way to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Nik
Here is another helpful link:
http://www.sql-server-performance.co...stall_main.asp
Regards
cT
"Nik" wrote:
> Hi All
> We are trying to consolidate all the SQL servers (more then 250 instances).
> We are considering Multi instance Sql Cluster on SAN
> Is there a document/weblink that expalins the SAN systems , and
> Installation/Setup of SQL Cluster on SAN.
> Pro's and Con's
> thanks in advance
>
>
|||thanks guys for prompt reply
Any info on SAN would be really helpful.
Like basics of SAN, Configuration parameters, Considerations of SQL on SAN
etc
"Charles Tolento" <CharlesTolento@.discussions.microsoft.com> wrote in
message news:DD97144D-BC43-493F-B2BD-E159AFE18829@.microsoft.com...
> Nik
> Here is another helpful link:
>
http://www.sql-server-performance.co...stall_main.asp[vbcol=seagreen]
> Regards
> cT
> "Nik" wrote:
instances).[vbcol=seagreen]
We are trying to consolidate all the SQL servers (more then 250 instances).
We are considering Multi instance Sql Cluster on SAN
Is there a document/weblink that expalins the SAN systems , and
Installation/Setup of SQL Cluster on SAN.
Pro's and Con's
thanks in advance
You may find the following links helpful
Server Consolidation
====================
Planning for Consolidation with SQL Server 2000 </technet/prodtechnol/sql/2000/plan/sql2kcon.mspx>
SQL Server Consolidation on the 64-bit Platform </technet/prodtechnol/sql/2000/deploy/64bitconsolidation.mspx>
SQL Server Consolidation on the 32-bit Platform Using a Clustered Environment </technet/prodtechnol/sql/2000/deploy/32bitconsolidation.mspx>
Microsoft SQL Server 2000 Scalability ProjectServer Consolidation <http://msdn.microsoft.com/library/de...asphosting.asp>
Additional Resources
===================
http://www.microsoft.com/sql/techinf...alability.mspx
http://www.microsoft.com/sql/techinf...ilability.mspx
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest
way to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Nik
Here is another helpful link:
http://www.sql-server-performance.co...stall_main.asp
Regards
cT
"Nik" wrote:
> Hi All
> We are trying to consolidate all the SQL servers (more then 250 instances).
> We are considering Multi instance Sql Cluster on SAN
> Is there a document/weblink that expalins the SAN systems , and
> Installation/Setup of SQL Cluster on SAN.
> Pro's and Con's
> thanks in advance
>
>
|||thanks guys for prompt reply
Any info on SAN would be really helpful.
Like basics of SAN, Configuration parameters, Considerations of SQL on SAN
etc
"Charles Tolento" <CharlesTolento@.discussions.microsoft.com> wrote in
message news:DD97144D-BC43-493F-B2BD-E159AFE18829@.microsoft.com...
> Nik
> Here is another helpful link:
>
http://www.sql-server-performance.co...stall_main.asp[vbcol=seagreen]
> Regards
> cT
> "Nik" wrote:
instances).[vbcol=seagreen]
Subscribe to:
Posts (Atom)