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 transfer or export dbf file to SQL server 2005 express edition?

I need to transfer dbf file to sql server 2005 express edition with some periodic interval. Can any one please recommend which is the easiest and efficient method to do?. Like polling every 5 to 10 seconds transfer data to sql server 2005 ex edition.

Is it recommend to do it visual basic program?, how to do it. pls help

Hi Stephen,

In SQL 2005 you can set up a linked server, a stored procedure, and a recurring job to run the stored procedure. I'm assuming you want to import only new or changed rows from the DBF and the stored procedure would allow you to do this before you update your main table.

I don't usually work with SQL Express, and I see that you can set up a linked server, but SQL Server Agent is not available to set up the recurring job. However, you could write an external program (such as in VB) to call the stored procedure at the desired intervals.

How to transfer database to mobile device?

Hi all, I'm new to mobile devices.

I have a desktop application that uses SQL Server Compact Edition. I will soon have a mobile application that will use the same database. How can I (at runtime of the desktop app, say when the user clicks a button) transfer the sdf file to the mobile device? I'm not necessarily interested in synchronizing the databases, simply overwriting the database on the mobile device with the one on the desktop would suffice.

Is something like this possible?

Thanks!

You can copy the SDF file from the desktop to the device using RAPI.|||Thanks, I'll check that out.

How to To transfer SQL server Express to web hosting Provider

Hello,

FYI, I'm using Visual Studion 2005 with SQL server Ex Edition in my developer PC. So the problem now is how i can migrate the database into my web hostin provider?. The provider also use the same version of SQl server. What i noticed the express editon dont have function to import or export.

Anybody iin here know how to solve? Right now, i'm create the databse using my controll panel in my web hosting then i create tables using management studio express, this way i must do twice works, 1st in my developer PC then into my web hosting..please anybody give a hand please

I already copy web site include the app_data into my web hosting, but unfortunately i dont know the connections strings? when i ask the provider they told me to use the management studio for the databse for connection into their server.

i also noticed if i install the application which use sql server dataabse it can be install the database including the tables and the data, so how is it i want to make my web site including the database be like installer. Like CommunityServer Forum? i just install into web hosting..is it possible? How the way? Thank you

note: I'm newbie in VS and Sql server

Please some one in here...I'm really needs this solution..i must create new application using VWD and SQL ex..i have a dateline..please the expert on in here..|||

Hosters each have their own way to allow you to move your database from the development environment onto the hosting platform. I can't tell how your hoster expects this to be done from your post.

Many Hosters will create a database for you and then let you create objects in the database they give you. Typically they provide you with some kind of web interface to accomplish this. It is common for Hosters to provide you with a way to run scripts to create objects in your hosted databases. If that is the case, you might be interested in the Database Publishing Wizard which we have just made available as a Community Technology Preview. The DPW is a new tool we are working on to make it easier to move databases from development to Hosting site using scripts. This is a CTP, so it's an earlier release. There is more information on the site about how to use the tool.

It sounds like your Hoster might allow you to connect Management Studio to thier site. If that is the case, you can still use this tool to generate your entire database as a script file and then use Management Studio to run the script when you're attached to the Hosters server.

You're right that Import/Export isn't part of SQL Express, but this tools should meet the need for uploading databases to a web hoster.

Mike

|||Thank you for your reply, I'm using Sql server 2005 Express Edition. Is it Database Publishing Wizard valid with this Sql Server Version.|||Sorry one more things,,is ti possible if we doing a mirroring databse using sql server express edition. If it can how the way? For example, i want mirror my databse from my web hosting provider with my PC in mmy office. is it possible? Thank you|||

I alrealdy install the database Publishing wizard but the problem is i'm a newbie and i do not know how to use it. When i open it just only Ms dos appear. Is it normal?

For Information, my web hosting provider use Plesk control..so the database is store through Plesk system. So with this scenario is it some body in here have an experience like me..Please tell me how the way?

|||

The Database Publishing Wizard is compatible with all Editions of SQL Server 2005. It may also be compatible with SQL 2000, I'm not sure. We're in CTP right now for the DPW, so it's not complete; this first release only supports a command line interface so it is normal that it just opens the DOS window when you run it. You will need to type your commands in at the drive> prompt per the instructions listed in the window. Some basic usage information is available on the tool site and there is a forum there also where you can post questions specific to the wizard.

I'm not familiar with Plesk so I'll have to let someone else advise you there. You will probably need to get more information directly from the technical support team at your web hoster site if you have problems working with thier interface.

Mike

How to To transfer SQL server Express to web hosting Provider

Hello,

FYI, I'm using Visual Studion 2005 with SQL server Ex Edition in my developer PC. So the problem now is how i can migrate the database into my web hostin provider??. The provider also use the same version of SQl server. What i noticed the expree editon dont have function to import or export.

Anybody iin here know how to solve? Right now, i'm create the databse using my controll panel in my web hosting then i create tables usin management studio express, this way i must do twice works, 1st in my developer PC then into my web hosting..please anybody give a hand please

You can move the .mdf file (the database file) to the server, so you don't need to import or export data.

|||

Tq for the reply, I already copy web site include the app_data into my web hosting, but unfortunately i dont know the connections strings?? when i ask the provider they told me to use the management studio for the databse for connection into their server. But i also noticed if i install the application which use sql server dataabse it can run, so how is it i wanto make my web site including the database be like installer..so i just install into web hosting..is it possible??

note: I'm newbie in VS and Sql server

|||I've heard that creating database can be included in application installer. However you still need to change your connection string to connect to the new SQL instance, so that the database created by the installer can be attached to the new SQL instance.|||So anybody in here can help me.. please..i need a way..i have a dateline..huhuh|||Hello friends,, I really need this solutions, please somebody in here..can anyone give any suggestion?? Thank you|||

Check out the new Database Publishing Wizard on Codeplex athttp://www.codeplex.com/Wiki/View.aspx?ProjectName=sqlhost&title=Database%20Publishing%20Wizard

We've just released out first CTP and we've still got a ways to go on perfecting it, but there's a good chance it'll help you.

Thanks,

Dan Winn

Senior Program Manager, Microsoft SQL Server

|||Tq for the reply..i already install it..but unfortunately i'm do not know how to use it..i prefer use with GUI...can u help me the steps how to use it? anyway thanks again for the reply

How to tell which edition of SQL Server 2005 is installed?

Since there are several different editions of SQL Server 2005, how can I find out which edition is installed? Is there a command or a menu item that can display this information? Help->About only gives the version number, not the edition name. I needed to find out whether the SQL Server 2005 on a machine is the Enterprise edtion or not.

Thanks,
Dandan

If you have Database Services installed, you can run T-SQL query "PRINT @.@.version" to find out.|||

This works great. Thanks very much :)

Dandan

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 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 the database online/ bring it offline by command prompt?

Hi,
I now using MS SQL SERVER Desktop Edition, as I know there is no enterpirse
belongs with this edition. I would like to perform a task that is provided
in the enterprise manager.
The task is "select a database--rightclick->All Tasks-->Taks Offline/Bring
Online"
The database file will then disconnect and connect to the server.
Anybody know how to perform the same task by command prompt as there is no
enterprise manager?
Thanks
RC
Hi,
From OSQL use the below commands:-
For Offline
ALTER DATABASE <DBNAME> SET OFFLINE
For Online
ALTER DATABASE <DBNAME> SET ONLINE
Note:
You have many options in ALTER DATABASE command, refer books online for more
information.
THanks
Hari
SQL Server MVP
"RC" <rc@.gmail.com> wrote in message
news:u2q2ST%23PFHA.3560@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I now using MS SQL SERVER Desktop Edition, as I know there is no
> enterpirse
> belongs with this edition. I would like to perform a task that is provided
> in the enterprise manager.
> The task is "select a database--rightclick->All Tasks-->Taks Offline/Bring
> Online"
> The database file will then disconnect and connect to the server.
> Anybody know how to perform the same task by command prompt as there is no
> enterprise manager?
> Thanks
> RC
>

how to supress instance name while logging to sql server 2005?

Hi,
I am using SQL server 2005 express edition on win XP installed on my machine
.
when I use the SQL server Management studio, I have to enter
machinename\SQLExpress .How can I connect using just machinenname and omit
the SQLExpress instancename?what settings do i need to do?
Thanks for your help.
regards,
tech@.77SQLExpress is the default instance name that is given to that edition when
you indtsll it. You could have changed it during the installation. You can
now only uninstall SQL Express and reintall it as the default instance.
But I would suggest you not to do that and leave it as it is, so that when
you are going for developer edition or any other edition at a later stage,
you might want it to run under default instance.
Hope this helps.

how to start work in SQL Server 2005 enterprise edition

Hi all,

I am new to SQL server. I just installed SQL Server 2005 enterprise edition .

I have not more experience in SQL but I need some tutorial about how to use SQL Server 2005 and create tables and make queries and relate tables . I can't find any exact location in Microsoft website about SQL Server enterprise edition and documentation where i can find beginner's resources. which feature we use for creating the tables and other features for making the database.

Can anyone please give me the location.

Thanks

Start by taking a look at the documentation that ships with SQL Server 2005 Enterprise Edition. There are samples and walk-throughs included in the documentation that are designed to get you started. Is that what you're looking for?

Jeff.

how to start work in SQL Server 2005 enterprise edition

Hi all,

I am new to SQL server. I just installed SQL Server 2005 enterprise edition .

I have not more experience in SQL but I need some tutorial about how to use SQL Server 2005 and create tables and make queries and relate tables . I can't find any exact location in Microsoft website about SQL Server enterprise edition and documentation where i can find beginner's resources. which feature we use for creating the tables and other features for making the database.

Can anyone please give me the location.

Thanks

If you have installed BOL(books online; help document that comes with SQL Server) use that. Almost all your questions will be answered in BOL. If you have not then install it.

How to start with ReportingServices

Hello,
We have MS_SQL_2000 Enterprise edition, but I can't find there
ReportingServices. Please, your help to guide me about getting started.
- DianaI started here:
http://www.microsoft.com/sql/reporting/default.asp
Good luck!
"Diana" wrote:
> Hello,
> We have MS_SQL_2000 Enterprise edition, but I can't find there
> ReportingServices. Please, your help to guide me about getting started.
> - Diana