How to transfer or migrate from old SQL cluster 2000 to new SQL cluster 2000

I have two Windows 2000 servers (Advance Edition) to form a Windows Cluster. I also install MS SQL 2000 Enterprise Edition on the cluster to form a MS SQL cluster. Now, I want to upgrade the hardware and OS (but keep on using SQL 2000), so I install Windows 2003 server Enterprise Edition on two new servers to form a new Windows Cluster. I am planing to install MS SQL 2000 Enterprise Edition on the new cluster, so the old SQL cluster and new SQL cluster are side by side. I would like to know how to setup a new SQL cluster (I know it has problem to rename SQL Cluster name, so how to fix this problem)? And how to transfer everything (such as system databases, users database, sql user account, password and maintenance plan jobs etc) from old SQL cluster to new SQL cluster? And how to switch over from old SQL cluster to new SQL cluster?

Thanks a lot !

This article which seems to be quite comprehensive:

http://vyaskn.tripod.com/moving_sql_server.htm

Though i've not done this for a while, broadly speaking i think you'll want to follow these steps:

1) install sql 2000 on the NEW cluster

2) backup all the databases (inc master, model, msdb)

3) detach the databases from the OLD cluster

4) move the files to the NEW cluster

5) restore the system databases on the NEW cluster

6) attach the user databases on the NEW cluster

You'll probably want to check out the sections in BOL about starting sql in single user mode and the info on sp_detach_db and sp_attach_db

Hope this helps!!

|||

Hi richbrownesq,

Thank you for your reply. The article is quite good. However it works for MS SQL single server, not for MS SQL Cluster.

The problem of MS SQL cluster is to rename the SQL Cluster name (i.e. switch over from old cluster to new cluster). If the new SQL cluster uses different cluster name from the old SQL Cluster, the job (created by old SQL cluster name) in new SQL cluster cannot be modified or deleted. So any idea to solve this problem?

Thanks !

|||

Sorry, can you expand on what you mean by:

"the job (created by old SQL cluster name) in new SQL cluster cannot be modified or deleted"

|||

For example, I create a scheduled backup job in old SQL cluster using Enterprise Manager to backup user databases. And now, I transfer everything (including the backup job) in old SQL cluster to new SQL cluster which uses different cluster name. However, I cannot modify or delete the scheduled backup job in new SQL cluster using Enterprise Manager, because the new SQL cluster name is different. The problem can be solved if the new SQL cluster name uses the same name, but how can I do so?

Thanks

|||

This may be due to the value of originating_server in msdb..sysjobs being the old clustername. Try updating the value of this to be your new cluster name in the form server/instance.

Hope that solves the problem.

|||

Updating the value of originating_server in msdb..sysjobs can solve the problem. Thanks!

By the way, if I setup a new SQL cluster with new cluster name and new cluster IP, and then I update the DNS entry (old SQL cluster name mapping to new SQL cluster IP) for switching over from old SQL cluster to new SQL cluster. Is it any drawback or potential problem using this switching over method?

Thanks a lot !

|||

I've not used this specific approach- i've generally been fortunate enough to only have one connection string and a decent size window of downtime to be able to just update it without worrying about DNS changes.

However, i know of people who use an approach similar to this for DR and it seems to work, so hopefully you won't see any issues.

Cheers

|||

Hi Richbrownesq,

Thank you very much !

How to trace a trace file?

SQL Server 2005 Enterprise 64-bit, clustered.
I've just discovered that there is a trace file being created on one of our
servers, but I can't figure out where it's being generated from. It's
tracing various Database Events (Data File Auto Grow, Data File Auto Shrink,
etc.), Error and Warning (Hash Warning, Missing Join Predicate, etc.), Full
Text (FT: Crawl Aborted, etc.), Objects (Object:Altered, etc.), Security
Audit (Audit Add DB User Event, etc.) and Server (Server Memory Change). I
can't see a process in the Activity Monitor that is from SQL Server
Profiler, so I'm a little stumped as to what this is.
I presume it could be caused by sp_trace_create but I'm not sure how I would
find which process, and more specifically which user, is running this.
Or is this possibly some kind of internal auditing capability that someone
has turned on, and if so, where do I find it?
Any help you can provide so I can track this down would be most gratefully
received.
Michael MacGregor
Database ArchitectPerhaps it is the default trace? Is this trace in the SQL Server LOG directo
ry (where the errorlog
file is)? If so, disable it using sp_configure (but remember that is it quit
e handy to have...).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Michael MacGregor" <nospam@.nospam.com> wrote in message
news:%23jLsRaInHHA.1244@.TK2MSFTNGP04.phx.gbl...
> SQL Server 2005 Enterprise 64-bit, clustered.
> I've just discovered that there is a trace file being created on one of ou
r servers, but I can't
> figure out where it's being generated from. It's tracing various Database
Events (Data File Auto
> Grow, Data File Auto Shrink, etc.), Error and Warning (Hash Warning, Missi
ng Join Predicate,
> etc.), Full Text (FT: Crawl Aborted, etc.), Objects (Object:Altered, etc.)
, Security Audit (Audit
> Add DB User Event, etc.) and Server (Server Memory Change). I can't see a
process in the Activity
> Monitor that is from SQL Server Profiler, so I'm a little stumped as to wh
at this is.
> I presume it could be caused by sp_trace_create but I'm not sure how I wou
ld find which process,
> and more specifically which user, is running this.
> Or is this possibly some kind of internal auditing capability that someone
has turned on, and if
> so, where do I find it?
> Any help you can provide so I can track this down would be most gratefully
received.
> Michael MacGregor
> Database Architect
>|||Hi Tibor,
Thanks for your prompt response.
Is there documentation on what the default trace contains, i.e. which events
it is monitoring? I took a quick look at BOL but there wasn't much in the
way of information about that under configuration options.
Thanks.
Michael MacGregor
Database Architect|||> Is there documentation on what the default trace contains, i.e. which even
ts it is monitoring?
Sure. Well, ...it depends on whether you want to call below "documentation"
or not... ;-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Michael MacGregor" <nospam@.nospam.com> wrote in message
news:%23VTr9hInHHA.2596@.TK2MSFTNGP06.phx.gbl...
> Hi Tibor,
> Thanks for your prompt response.
> Is there documentation on what the default trace contains, i.e. which even
ts it is monitoring? I
> took a quick look at BOL but there wasn't much in the way of information a
bout that under
> configuration options.
> Thanks.
> Michael MacGregor
> Database Architect
>|||So I presume then that there's not much in the way of "official"
documentation for this feature from Microsoft. Ain't that a surprise!
Thanks Tibor.
MTM|||Michael
I wrote an article about this trace when I discovered it. You're right, that
there is not a lot of documentation about it.
http://www.sqlmag.com/Article/Artic...or_a_Trace.html
You can open up any of the trace output files in the Profiler, and then when
you look at the properties of the trace you can see what is being traced.
As Tibor mentioned, you can disable it with sp_configure, if you decide that
it's the best thing to do.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Michael MacGregor" <nospam@.nospam.com> wrote in message
news:uLFbVnInHHA.568@.TK2MSFTNGP02.phx.gbl...
> So I presume then that there's not much in the way of "official"
> documentation for this feature from Microsoft. Ain't that a surprise!
> Thanks Tibor.
> MTM
>sql

How to trace a trace file?

SQL Server 2005 Enterprise 64-bit, clustered.
I've just discovered that there is a trace file being created on one of our
servers, but I can't figure out where it's being generated from. It's
tracing various Database Events (Data File Auto Grow, Data File Auto Shrink,
etc.), Error and Warning (Hash Warning, Missing Join Predicate, etc.), Full
Text (FT: Crawl Aborted, etc.), Objects (Object:Altered, etc.), Security
Audit (Audit Add DB User Event, etc.) and Server (Server Memory Change). I
can't see a process in the Activity Monitor that is from SQL Server
Profiler, so I'm a little stumped as to what this is.
I presume it could be caused by sp_trace_create but I'm not sure how I would
find which process, and more specifically which user, is running this.
Or is this possibly some kind of internal auditing capability that someone
has turned on, and if so, where do I find it?
Any help you can provide so I can track this down would be most gratefully
received.
Michael MacGregor
Database Architect
Perhaps it is the default trace? Is this trace in the SQL Server LOG directory (where the errorlog
file is)? If so, disable it using sp_configure (but remember that is it quite handy to have...).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Michael MacGregor" <nospam@.nospam.com> wrote in message
news:%23jLsRaInHHA.1244@.TK2MSFTNGP04.phx.gbl...
> SQL Server 2005 Enterprise 64-bit, clustered.
> I've just discovered that there is a trace file being created on one of our servers, but I can't
> figure out where it's being generated from. It's tracing various Database Events (Data File Auto
> Grow, Data File Auto Shrink, etc.), Error and Warning (Hash Warning, Missing Join Predicate,
> etc.), Full Text (FT: Crawl Aborted, etc.), Objects (Object:Altered, etc.), Security Audit (Audit
> Add DB User Event, etc.) and Server (Server Memory Change). I can't see a process in the Activity
> Monitor that is from SQL Server Profiler, so I'm a little stumped as to what this is.
> I presume it could be caused by sp_trace_create but I'm not sure how I would find which process,
> and more specifically which user, is running this.
> Or is this possibly some kind of internal auditing capability that someone has turned on, and if
> so, where do I find it?
> Any help you can provide so I can track this down would be most gratefully received.
> Michael MacGregor
> Database Architect
>
|||Hi Tibor,
Thanks for your prompt response.
Is there documentation on what the default trace contains, i.e. which events
it is monitoring? I took a quick look at BOL but there wasn't much in the
way of information about that under configuration options.
Thanks.
Michael MacGregor
Database Architect
|||> Is there documentation on what the default trace contains, i.e. which events it is monitoring?
Sure. Well, ...it depends on whether you want to call below "documentation" or not... ;-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Michael MacGregor" <nospam@.nospam.com> wrote in message
news:%23VTr9hInHHA.2596@.TK2MSFTNGP06.phx.gbl...
> Hi Tibor,
> Thanks for your prompt response.
> Is there documentation on what the default trace contains, i.e. which events it is monitoring? I
> took a quick look at BOL but there wasn't much in the way of information about that under
> configuration options.
> Thanks.
> Michael MacGregor
> Database Architect
>
|||So I presume then that there's not much in the way of "official"
documentation for this feature from Microsoft. Ain't that a surprise!
Thanks Tibor.
MTM
|||Michael
I wrote an article about this trace when I discovered it. You're right, that
there is not a lot of documentation about it.
http://www.sqlmag.com/Article/ArticleID/48939/Searching_for_a_Trace.html
You can open up any of the trace output files in the Profiler, and then when
you look at the properties of the trace you can see what is being traced.
As Tibor mentioned, you can disable it with sp_configure, if you decide that
it's the best thing to do.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Michael MacGregor" <nospam@.nospam.com> wrote in message
news:uLFbVnInHHA.568@.TK2MSFTNGP02.phx.gbl...
> So I presume then that there's not much in the way of "official"
> documentation for this feature from Microsoft. Ain't that a surprise!
> Thanks Tibor.
> MTM
>

How to trace a trace file?

SQL Server 2005 Enterprise 64-bit, clustered.
I've just discovered that there is a trace file being created on one of our
servers, but I can't figure out where it's being generated from. It's
tracing various Database Events (Data File Auto Grow, Data File Auto Shrink,
etc.), Error and Warning (Hash Warning, Missing Join Predicate, etc.), Full
Text (FT: Crawl Aborted, etc.), Objects (Object:Altered, etc.), Security
Audit (Audit Add DB User Event, etc.) and Server (Server Memory Change). I
can't see a process in the Activity Monitor that is from SQL Server
Profiler, so I'm a little stumped as to what this is.
I presume it could be caused by sp_trace_create but I'm not sure how I would
find which process, and more specifically which user, is running this.
Or is this possibly some kind of internal auditing capability that someone
has turned on, and if so, where do I find it?
Any help you can provide so I can track this down would be most gratefully
received.
Michael MacGregor
Database ArchitectPerhaps it is the default trace? Is this trace in the SQL Server LOG directory (where the errorlog
file is)? If so, disable it using sp_configure (but remember that is it quite handy to have...).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Michael MacGregor" <nospam@.nospam.com> wrote in message
news:%23jLsRaInHHA.1244@.TK2MSFTNGP04.phx.gbl...
> SQL Server 2005 Enterprise 64-bit, clustered.
> I've just discovered that there is a trace file being created on one of our servers, but I can't
> figure out where it's being generated from. It's tracing various Database Events (Data File Auto
> Grow, Data File Auto Shrink, etc.), Error and Warning (Hash Warning, Missing Join Predicate,
> etc.), Full Text (FT: Crawl Aborted, etc.), Objects (Object:Altered, etc.), Security Audit (Audit
> Add DB User Event, etc.) and Server (Server Memory Change). I can't see a process in the Activity
> Monitor that is from SQL Server Profiler, so I'm a little stumped as to what this is.
> I presume it could be caused by sp_trace_create but I'm not sure how I would find which process,
> and more specifically which user, is running this.
> Or is this possibly some kind of internal auditing capability that someone has turned on, and if
> so, where do I find it?
> Any help you can provide so I can track this down would be most gratefully received.
> Michael MacGregor
> Database Architect
>|||Hi Tibor,
Thanks for your prompt response.
Is there documentation on what the default trace contains, i.e. which events
it is monitoring? I took a quick look at BOL but there wasn't much in the
way of information about that under configuration options.
Thanks.
Michael MacGregor
Database Architect|||> Is there documentation on what the default trace contains, i.e. which events it is monitoring?
Sure. Well, ...it depends on whether you want to call below "documentation" or not... ;-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Michael MacGregor" <nospam@.nospam.com> wrote in message
news:%23VTr9hInHHA.2596@.TK2MSFTNGP06.phx.gbl...
> Hi Tibor,
> Thanks for your prompt response.
> Is there documentation on what the default trace contains, i.e. which events it is monitoring? I
> took a quick look at BOL but there wasn't much in the way of information about that under
> configuration options.
> Thanks.
> Michael MacGregor
> Database Architect
>|||So I presume then that there's not much in the way of "official"
documentation for this feature from Microsoft. Ain't that a surprise!
Thanks Tibor.
MTM|||Michael
I wrote an article about this trace when I discovered it. You're right, that
there is not a lot of documentation about it.
http://www.sqlmag.com/Article/ArticleID/48939/Searching_for_a_Trace.html
You can open up any of the trace output files in the Profiler, and then when
you look at the properties of the trace you can see what is being traced.
As Tibor mentioned, you can disable it with sp_configure, if you decide that
it's the best thing to do.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Michael MacGregor" <nospam@.nospam.com> wrote in message
news:uLFbVnInHHA.568@.TK2MSFTNGP02.phx.gbl...
> So I presume then that there's not much in the way of "official"
> documentation for this feature from Microsoft. Ain't that a surprise!
> Thanks Tibor.
> MTM
>

How to tell which version is installed

Regarding SQL server 2000
How do you tell...
1. Which version is installed (Enterprise / Standard / Developer etc.) ?
2. The service packs installed to date ?
Thankshttp://www.aspfaq.com/show.asp?id=2160
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rob C" <rwc1960@.bellsouth.net> wrote in message news:JmPad.77189$yp.12057@.bignews1.bellsout
h.net...
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>|||I use serverproperty
select serverproperty('productlevel' )
See serverproperty in Books on line
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rob C" <rwc1960@.bellsouth.net> wrote in message
news:JmPad.77189$yp.12057@.bignews1.bellsouth.net...
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>

How to tell which version is installed

Regarding SQL server 2000
How do you tell...
1. Which version is installed (Enterprise / Standard / Developer etc.) ?
2. The service packs installed to date ?
Thanks
http://www.aspfaq.com/show.asp?id=2160
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rob C" <rwc1960@.bellsouth.net> wrote in message news:JmPad.77189$yp.12057@.bignews1.bellsouth.net.. .
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>
|||I use serverproperty
select serverproperty('productlevel' )
See serverproperty in Books on line
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rob C" <rwc1960@.bellsouth.net> wrote in message
news:JmPad.77189$yp.12057@.bignews1.bellsouth.net.. .
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>

How to tell which version is installed

Regarding SQL server 2000
How do you tell...
1. Which version is installed (Enterprise / Standard / Developer etc.) ?
2. The service packs installed to date ?
Thankshttp://www.aspfaq.com/show.asp?id=2160
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rob C" <rwc1960@.bellsouth.net> wrote in message news:JmPad.77189$yp.12057@.bignews1.bellsouth.net...
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>|||I use serverproperty
select serverproperty('productlevel' )
See serverproperty in Books on line
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rob C" <rwc1960@.bellsouth.net> wrote in message
news:JmPad.77189$yp.12057@.bignews1.bellsouth.net...
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>

How to tell what version of SQL Server.

If I am running an MSDN version of SQL Server how would I be able to tell
using Query Analyzer?
I tried @.@.Version ... but it says Enterprise Edition ... when I know I have
install MSDN copy.
-LarsPlease check it out at the following link
http://sqljunkies.com/weblog/sqlpartner/posts/802.aspx
HTH
Satish Balusa
Corillian Corp.
"Lars Temme" <no_spam@.L+A+R+S.T+E+M+M+E@.fsc.fiserv.com> wrote in message
news:OgSYCYb6DHA.1592@.TK2MSFTNGP10.phx.gbl...

quote:

---

> If I am running an MSDN version of SQL Server how would I be able to tell
> using Query Analyzer?
> I tried @.@.Version ... but it says Enterprise Edition ... when I know I

---

have

quote:

---

> install MSDN copy.
> -Lars
>

---

|||Still does not tell me whether server is running MSDN copy of SQL Server.
Perhaps this is not possiable.
-Lars
"Satish Balusa" <sbalusa_nospam@.corillian.com> wrote in message
news:%23RDv9cb6DHA.3860@.tk2msftngp13.phx.gbl...

quote:

---

> Please check it out at the following link
> http://sqljunkies.com/weblog/sqlpartner/posts/802.aspx
>
> --
> HTH
> Satish Balusa
> Corillian Corp.
>
> "Lars Temme" <no_spam@.L+A+R+S.T+E+M+M+E@.fsc.fiserv.com> wrote in message
> news:OgSYCYb6DHA.1592@.TK2MSFTNGP10.phx.gbl...
tell[QUOTE]
> have
>

---

|||There's no such thing as an MSDN version of SQL Server. The MSDN people at M
S quite simply shipped
MSDN with the edition they found most appropriate. In the beginning of SQL2K
, you had all editions
and after a while the shipments only contained the developer edition.
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Lars Temme" <no_spam@.L+A+R+S.T+E+M+M+E@.fsc.fiserv.com> wrote in message
news:ukZJsub6DHA.2064@.TK2MSFTNGP11.phx.gbl...

quote:

---

> Still does not tell me whether server is running MSDN copy of SQL Server.
> Perhaps this is not possiable.
> -Lars
> "Satish Balusa" <sbalusa_nospam@.corillian.com> wrote in message
> news:%23RDv9cb6DHA.3860@.tk2msftngp13.phx.gbl...
> tell
>

---

How to tell what version of SQL Server.

If I am running an MSDN version of SQL Server how would I be able to tell
using Query Analyzer?
I tried @.@.Version ... but it says Enterprise Edition ... when I know I have
install MSDN copy.
-LarsPlease check it out at the following link
http://sqljunkies.com/weblog/sqlpartner/posts/802.aspx
HTH
Satish Balusa
Corillian Corp.
"Lars Temme" <no_spam@.L+A+R+S.T+E+M+M+E@.fsc.fiserv.com> wrote in message
news:OgSYCYb6DHA.1592@.TK2MSFTNGP10.phx.gbl...
> If I am running an MSDN version of SQL Server how would I be able to tell
> using Query Analyzer?
> I tried @.@.Version ... but it says Enterprise Edition ... when I know I
have
> install MSDN copy.
> -Lars
>|||Still does not tell me whether server is running MSDN copy of SQL Server.
Perhaps this is not possiable.
-Lars
"Satish Balusa" <sbalusa_nospam@.corillian.com> wrote in message
news:%23RDv9cb6DHA.3860@.tk2msftngp13.phx.gbl...
> Please check it out at the following link
> http://sqljunkies.com/weblog/sqlpartner/posts/802.aspx
>
> --
> HTH
> Satish Balusa
> Corillian Corp.
>
> "Lars Temme" <no_spam@.L+A+R+S.T+E+M+M+E@.fsc.fiserv.com> wrote in message
> news:OgSYCYb6DHA.1592@.TK2MSFTNGP10.phx.gbl...
> > If I am running an MSDN version of SQL Server how would I be able to
tell
> > using Query Analyzer?
> > I tried @.@.Version ... but it says Enterprise Edition ... when I know I
> have
> > install MSDN copy.
> >
> > -Lars
> >
> >
>|||There's no such thing as an MSDN version of SQL Server. The MSDN people at MS quite simply shipped
MSDN with the edition they found most appropriate. In the beginning of SQL2K, you had all editions
and after a while the shipments only contained the developer edition.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Lars Temme" <no_spam@.L+A+R+S.T+E+M+M+E@.fsc.fiserv.com> wrote in message
news:ukZJsub6DHA.2064@.TK2MSFTNGP11.phx.gbl...
> Still does not tell me whether server is running MSDN copy of SQL Server.
> Perhaps this is not possiable.
> -Lars
> "Satish Balusa" <sbalusa_nospam@.corillian.com> wrote in message
> news:%23RDv9cb6DHA.3860@.tk2msftngp13.phx.gbl...
> > Please check it out at the following link
> >
> > http://sqljunkies.com/weblog/sqlpartner/posts/802.aspx
> >
> >
> > --
> > HTH
> > Satish Balusa
> > Corillian Corp.
> >
> >
> > "Lars Temme" <no_spam@.L+A+R+S.T+E+M+M+E@.fsc.fiserv.com> wrote in message
> > news:OgSYCYb6DHA.1592@.TK2MSFTNGP10.phx.gbl...
> > > If I am running an MSDN version of SQL Server how would I be able to
> tell
> > > using Query Analyzer?
> > > I tried @.@.Version ... but it says Enterprise Edition ... when I know I
> > have
> > > install MSDN copy.
> > >
> > > -Lars
> > >
> > >
> >
> >
>

How to tell what version of SQL 2005 is intalled (Enterprise or standard)

I need to make sure that the proper version of SQL Server 2005 was installed on the production server.

What do I do to find out?

Thanks in advance!

Connect to the instance using SQLCMD and run:

1> select @.@.version;
2> go

You should get output that looks like:

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

The 9.00.1399.06 is the version for SQL Server 2005 RTM.

Or from SQLCMD you can run:

1> select CONVERT(char(20), SERVERPROPERTY('productversion'));
2> go

Which will output:

9.00.1399.06

Also, if you connect to the server using SQL Server Management Studio, the version is displayed in Object Explorer on the root server node. Here it's displayed as 9.00.1399.

Cheers,
Dan

|||

Key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup

Name: Edition

Type: REG_SZ

Data: Enterprise Edition

This result supports you install SQL Server 2005 on a clean machine. Most often, you should check the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.n\Setup if you install multiple instances.

|||

In my previous posting,

"This result supports you install SQL Server 2005 on a clean machine."

should be

"This result supposes you install SQL Server 2005 ENT on a clean machine."

In addition, you can also get the version information from the registry key by checking the value of "Version".

sql

How to tell version difference between 2000 Enterprise vs. Standard

I have kind of an urgent need here. I need to know if there is a dll file or registry key or something of that nature that I can query on to find out if my SQL 2000 installations are Enterprise or Standard.

I understand I can do this using query analyser, but that will not work with my reporting tool (this is for reporting numbers of SQL installations in our very large enterprise for Microsoft license compliance).

Thanks for any guidance!!

Cheryl Marland

cheryl.marland@.va.gov

In SQL 2000 that information is not written to the registry in a readable format.

If you can't run osql in the discovery process, you could create a windows batch file that's scheduled to run every night at midnight - the batch job could run

select convert(char(20), serverproperty('edition'))
go

and dump the results to an output file. If you can't read the file you could author the script to update a reg key with the information so you're reporting process could pick it up.

Cheers,
Dan

|||

Dan,

Is this info more readily available in SQL 2005?

How to tell version difference between 2000 Enterprise vs. Standard

I have kind of an urgent need here. I need to know if there is a dll file or registry key or something of that nature that I can query on to find out if my SQL 2000 installations are Enterprise or Standard.

I understand I can do this using query analyser, but that will not work with my reporting tool (this is for reporting numbers of SQL installations in our very large enterprise for Microsoft license compliance).

Thanks for any guidance!!

Cheryl Marland

cheryl.marland@.va.gov

In SQL 2000 that information is not written to the registry in a readable format.

If you can't run osql in the discovery process, you could create a windows batch file that's scheduled to run every night at midnight - the batch job could run

select convert(char(20), serverproperty('edition'))
go

and dump the results to an output file. If you can't read the file you could author the script to update a reg key with the information so you're reporting process could pick it up.

Cheers,
Dan

|||

Dan,

Is this info more readily available in SQL 2005?

How to tell if I have the Personal or Enterprise Edition of SQL 7.0

I am currently running SQL 7.0 on a Win2k workstation but wish to upgrade
how to I know which edition I have?
Thanks,
DanSolex,
From KB321185 :
How to Determine Which Edition of SQL Server is Running
If you are not sure about what edition of SQL Server you are running, the
last line of output that is returned by @.@.VERSION reports the edition to
which you have connected. The example that is used in this article is the
Standard Edition of SQL Server 2000 on Windows NT 5.0 (Build 2195: Service
Pack 2) Note The build and service pack information provided earlier is for
the operating system, not for SQL Server.
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"solex" <solex@.nowhere.com> wrote in message
news:urKWw9LaDHA.736@.TK2MSFTNGP09.phx.gbl...
> I am currently running SQL 7.0 on a Win2k workstation but wish to upgrade
> how to I know which edition I have?
> Thanks,
> Dan
>|||So the desktop edition is the same as the personal edition?
Thanks,
Dan
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:OITp%23$LaDHA.2580@.TK2MSFTNGP09.phx.gbl...
> In Query Analyser do this
> SELECT @.@.version
> --
>
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org|||Try:
SELECT @.@.VERSION
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"solex" <solex@.nowhere.com> wrote in message
news:urKWw9LaDHA.736@.TK2MSFTNGP09.phx.gbl...
> I am currently running SQL 7.0 on a Win2k workstation but wish to
upgrade
> how to I know which edition I have?
> Thanks,
> Dan
>|||Is there any thing I should look out for when upgrading from the Desktop
Edtion 7.0 to the Personal Edition 2k?
Thanks,
Dan
"solex" <solex@.nowhere.com> wrote in message
news:urKWw9LaDHA.736@.TK2MSFTNGP09.phx.gbl...
> I am currently running SQL 7.0 on a Win2k workstation but wish to upgrade
> how to I know which edition I have?
> Thanks,
> Dan
>|||Dan,
In SQL2000, "desktop" edition(DE) was renamed to "personal" edition(PE).You
can upgrade SQL Server 7.0 DE to SQL2000 PE.Just pop in the setup CD and
select 'upgrade existing installation...' and it should go fine.On a
successful upgrade, all your SQL7 databases would be upgraded to SQL2000
ones.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"solex" <solex@.nowhere.com> wrote in message
news:%23d%23Z3DMaDHA.2284@.TK2MSFTNGP12.phx.gbl...
> Is there any thing I should look out for when upgrading from the Desktop
> Edtion 7.0 to the Personal Edition 2k?
> Thanks,
> Dan
> "solex" <solex@.nowhere.com> wrote in message
> news:urKWw9LaDHA.736@.TK2MSFTNGP09.phx.gbl...
> > I am currently running SQL 7.0 on a Win2k workstation but wish to
upgrade
> > how to I know which edition I have?
> >
> > Thanks,
> > Dan
> >
> >
>|||Thank You All!
"solex" <solex@.nowhere.com> wrote in message
news:urKWw9LaDHA.736@.TK2MSFTNGP09.phx.gbl...
> I am currently running SQL 7.0 on a Win2k workstation but wish to upgrade
> how to I know which edition I have?
> Thanks,
> Dan
>

how to tell expiration date of eval version

First question: I have sql server 2005 enterprise eval edition installed. is there a query, command or tool can tell me the exact expiration date? I understand it is 180 day but I still want some way to query the exact date.

Second question: does sql server log any warning message before eval expires?

Simply look at the creation date of the SQL folders. There is a message in the event log telling about the expiration date of SQL Server.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

How to take back up using query analyzer

Hi
Can anybody tell me how to take database back up using query analyzer in sql
server 2000?
i dont want in enterprise manager i wnat to know how to do it with query
analyzer.
can you tell me y i'm getting this error when i'm trying to open enterprise
manager
"SQLDMO has not been registered, please re-run SQL SERVER setup and contact
your system administrator"
i can re-run setup but i need to take back up first and it is not giving any
error when opening sql query analyzer.
so can any one tell me
Thanx in advance
JyothiAnswered in microsoft.public.sqlserver.programming
Please do not multi-post.
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/
"yoshitha" <gudivada_kmm@.yahoo.co.in> wrote in message
news:%23uGZUP%23$FHA.1312@.TK2MSFTNGP09.phx.gbl...
> Hi
> Can anybody tell me how to take database back up using query analyzer in
> sql server 2000?
> i dont want in enterprise manager i wnat to know how to do it with query
> analyzer.
> can you tell me y i'm getting this error when i'm trying to open
> enterprise manager
> "SQLDMO has not been registered, please re-run SQL SERVER setup and
> contact your system administrator"
> i can re-run setup but i need to take back up first and it is not giving
> any error when opening sql query analyzer.
> so can any one tell me
> Thanx in advance
> Jyothi
>

How to take back up using query analyzer

Hi
Can anybody tell me how to take database back up using query analyzer in sql
server 2000?
i dont want in enterprise manager i wnat to know how to do it with query
analyzer.
can you tell me y i'm getting this error when i'm trying to open enterprise
manager
"SQLDMO has not been registered, please re-run SQL SERVER setup and contact
your system administrator"
i can re-run setup but i need to take back up first and it is not giving any
error when opening sql query analyzer.
so can any one tell me
Thanx in advance
Jyothi
Answered in microsoft.public.sqlserver.programming
Please do not multi-post.
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/
"yoshitha" <gudivada_kmm@.yahoo.co.in> wrote in message
news:%23uGZUP%23$FHA.1312@.TK2MSFTNGP09.phx.gbl...
> Hi
> Can anybody tell me how to take database back up using query analyzer in
> sql server 2000?
> i dont want in enterprise manager i wnat to know how to do it with query
> analyzer.
> can you tell me y i'm getting this error when i'm trying to open
> enterprise manager
> "SQLDMO has not been registered, please re-run SQL SERVER setup and
> contact your system administrator"
> i can re-run setup but i need to take back up first and it is not giving
> any error when opening sql query analyzer.
> so can any one tell me
> Thanx in advance
> Jyothi
>

How to take back up using query analyzer

Hi
Can anybody tell me how to take database back up using query analyzer in sql
server 2000?
i dont want in enterprise manager i wnat to know how to do it with query
analyzer.
can you tell me y i'm getting this error when i'm trying to open enterprise
manager
"SQLDMO has not been registered, please re-run SQL SERVER setup and contact
your system administrator"
i can re-run setup but i need to take back up first and it is not giving any
error when opening sql query analyzer.
so can any one tell me
Thanx in advance
JyothiAnswered in microsoft.public.sqlserver.programming
Please do not multi-post.
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/
"yoshitha" <gudivada_kmm@.yahoo.co.in> wrote in message
news:%23uGZUP%23$FHA.1312@.TK2MSFTNGP09.phx.gbl...
> Hi
> Can anybody tell me how to take database back up using query analyzer in
> sql server 2000?
> i dont want in enterprise manager i wnat to know how to do it with query
> analyzer.
> can you tell me y i'm getting this error when i'm trying to open
> enterprise manager
> "SQLDMO has not been registered, please re-run SQL SERVER setup and
> contact your system administrator"
> i can re-run setup but i need to take back up first and it is not giving
> any error when opening sql query analyzer.
> so can any one tell me
> Thanx in advance
> Jyothi
>

how to take back up

Hi
Can anybody tell me how to take database back up using query analyzer in sql
server 2000?
i dont want in enterprise manager i wnat to know how to do it with query
analyzer.
can you tell me y i'm getting this error when i'm trying to open enterprise
manager
"SQLDMO has not been registered, please re-run SQL SERVER setup and contact
your system administrator"
i can re-run setup but i need to take back up first and it is not giving any
error when opening sql query analyzer.
so can any one tell me
Thanx in advance
JyothiBACKUP DATABASE <dbname>
TO DISK = "d:\temp\backup.bak"
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/
"yoshitha" <gudivada_kmm@.yahoo.co.in> wrote in message
news:eA81FP%23$FHA.216@.TK2MSFTNGP15.phx.gbl...
> Hi
> Can anybody tell me how to take database back up using query analyzer in
> sql server 2000?
> i dont want in enterprise manager i wnat to know how to do it with query
> analyzer.
> can you tell me y i'm getting this error when i'm trying to open
> enterprise manager
> "SQLDMO has not been registered, please re-run SQL SERVER setup and
> contact your system administrator"
> i can re-run setup but i need to take back up first and it is not giving
> any error when opening sql query analyzer.
> so can any one tell me
> Thanx in advance
> Jyothi
>|||Hi
Check out the description of the backup command in Books online or at
http://msdn.microsoft.com/library/d...asp?frame=true
John
"yoshitha" wrote:

> Hi
> Can anybody tell me how to take database back up using query analyzer in s
ql
> server 2000?
> i dont want in enterprise manager i wnat to know how to do it with query
> analyzer.
> can you tell me y i'm getting this error when i'm trying to open enterpris
e
> manager
> "SQLDMO has not been registered, please re-run SQL SERVER setup and contac
t
> your system administrator"
> i can re-run setup but i need to take back up first and it is not giving a
ny
> error when opening sql query analyzer.
> so can any one tell me
> Thanx in advance
> Jyothi
>
>

how to take a db into unrecovery mode and apply more log backups?

In SQL Server Enterprise Manager, I restored a db from its full, diff and two
log backups (there are 4 log backups for this db) and left the database
operational. But I did not find what I need in the restored db. So I wanted
to apply the rest two log backups to the db. What should I do to the
currently operational db so that I can apply more log backups on it?
Thanks,
BingBing,
From your comment, I assume that you have done something in the database and
may not be able to restore old logs any longer. I believe that you needed
to do your earlier restores with the STANDBY option. As below from the BOL:
STANDBY = undo_file_name
STANDBY allows a database to be brought up for read-only access between
transaction log restores and can be used with either warm standby server
situations or special recovery situations in which it is useful to inspect
the database between log restores.
RLF
"bing" <bing@.discussions.microsoft.com> wrote in message
news:76F7D171-AE5D-4A08-A489-87A0DB186724@.microsoft.com...
> In SQL Server Enterprise Manager, I restored a db from its full, diff and
two
> log backups (there are 4 log backups for this db) and left the database
> operational. But I did not find what I need in the restored db. So I
wanted
> to apply the rest two log backups to the db. What should I do to the
> currently operational db so that I can apply more log backups on it?
> Thanks,
> Bing|||Thanks, Russell. You read me right. And STANDBY is just what I need to do.
Bing
"Russell Fields" wrote:
> Bing,
> From your comment, I assume that you have done something in the database and
> may not be able to restore old logs any longer. I believe that you needed
> to do your earlier restores with the STANDBY option. As below from the BOL:
> STANDBY = undo_file_name
> STANDBY allows a database to be brought up for read-only access between
> transaction log restores and can be used with either warm standby server
> situations or special recovery situations in which it is useful to inspect
> the database between log restores.
> RLF
> "bing" <bing@.discussions.microsoft.com> wrote in message
> news:76F7D171-AE5D-4A08-A489-87A0DB186724@.microsoft.com...
> > In SQL Server Enterprise Manager, I restored a db from its full, diff and
> two
> > log backups (there are 4 log backups for this db) and left the database
> > operational. But I did not find what I need in the restored db. So I
> wanted
> > to apply the rest two log backups to the db. What should I do to the
> > currently operational db so that I can apply more log backups on it?
> >
> > Thanks,
> >
> > Bing
>
>

how to take a db into unrecovery mode and apply more log backups?

In SQL Server Enterprise Manager, I restored a db from its full, diff and two
log backups (there are 4 log backups for this db) and left the database
operational. But I did not find what I need in the restored db. So I wanted
to apply the rest two log backups to the db. What should I do to the
currently operational db so that I can apply more log backups on it?
Thanks,
Bing
Bing,
From your comment, I assume that you have done something in the database and
may not be able to restore old logs any longer. I believe that you needed
to do your earlier restores with the STANDBY option. As below from the BOL:
STANDBY = undo_file_name
STANDBY allows a database to be brought up for read-only access between
transaction log restores and can be used with either warm standby server
situations or special recovery situations in which it is useful to inspect
the database between log restores.
RLF
"bing" <bing@.discussions.microsoft.com> wrote in message
news:76F7D171-AE5D-4A08-A489-87A0DB186724@.microsoft.com...
> In SQL Server Enterprise Manager, I restored a db from its full, diff and
two
> log backups (there are 4 log backups for this db) and left the database
> operational. But I did not find what I need in the restored db. So I
wanted
> to apply the rest two log backups to the db. What should I do to the
> currently operational db so that I can apply more log backups on it?
> Thanks,
> Bing