Moving Log Files: upgrade

Showing posts with label upgrade. Show all posts

Monday, March 19, 2012

Moving SQL Server 2000 to SQL Server 2005 - Need suggestions onsyncronization of data betw

Moving SQL Server 2000 to SQL Server 2005 - Need suggestions on

Hi,
Our current production database server is SQL Server 2000 and it is
running on Windows 2000 server.
Now as part of the upgrade we bouht a new machine and installed
Windows 2003 Server and SQL Server 2005 on it.
Now our idea is to move the databases from the current production to
the new SQL Server 2005. 1).How do we do that? Is it just do a
restore
of the most recent back up of a particular database on the new new
SQL
Server 2005?
2).Also we are thinking to syncronize the data between the current
production server and the new SQL Server 2005. So that at one point
it
thins are ok then we could point the web app to the new SQL Server
2005 which is currently pointing to the current production SQL
Server .
In other words how do make transition from the current SQL Server
2000
to our new SQL Server 2005?
Can any body suggest me a starting point on this on how do we do
this?
Your help is hihly appreciated.
Thanks,
-LPlease don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Learner" <pradev@.gmail.com> wrote in message
news:d505cae9-2eb0-4b27-9e1b-2a3a3fbab7c2@.o6g2000hsd.googlegroups.com...
> Hi,
> Our current production database server is SQL Server 2000 and it is
> running on Windows 2000 server.
>
> Now as part of the upgrade we bouht a new machine and installed
> Windows 2003 Server and SQL Server 2005 on it.
>
> Now our idea is to move the databases from the current production to
> the new SQL Server 2005. 1).How do we do that? Is it just do a
> restore
> of the most recent back up of a particular database on the new new
> SQL
> Server 2005?
>
> 2).Also we are thinking to syncronize the data between the current
> production server and the new SQL Server 2005. So that at one point
> it
> thins are ok then we could point the web app to the new SQL Server
> 2005 which is currently pointing to the current production SQL
> Server .
>
> In other words how do make transition from the current SQL Server
> 2000
> to our new SQL Server 2005?
>
> Can any body suggest me a starting point on this on how do we do
> this?
> Your help is hihly appreciated.
>
> Thanks,
>
> -L
>|||Some recommendations to get started:
1) Run SQL Server Upgrade Advisor on your database and follow its
recommendations
2) Check the BOL section 'Upgrading to SQL Server 2005'
4) Take a look at this and see which sections apply to your case
http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en
3) Restore a copy of your database in SQL Server 2005 and start testing your
application
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Learner" wrote:
> Hi,
> Our current production database server is SQL Server 2000 and it is
> running on Windows 2000 server.
>
> Now as part of the upgrade we bouht a new machine and installed
> Windows 2003 Server and SQL Server 2005 on it.
>
> Now our idea is to move the databases from the current production to
> the new SQL Server 2005. 1).How do we do that? Is it just do a
> restore
> of the most recent back up of a particular database on the new new
> SQL
> Server 2005?
>
> 2).Also we are thinking to syncronize the data between the current
> production server and the new SQL Server 2005. So that at one point
> it
> thins are ok then we could point the web app to the new SQL Server
> 2005 which is currently pointing to the current production SQL
> Server .
>
> In other words how do make transition from the current SQL Server
> 2000
> to our new SQL Server 2005?
>
> Can any body suggest me a starting point on this on how do we do
> this?
> Your help is hihly appreciated.
>
> Thanks,
>
> -L
>
>|||On Nov 28, 1:00 pm, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
wrote:
> Please don't post independently in separate newsgroups. You can add
> multiple newsgroups to the header and then all the answers appear as one.
> See my reply in the other newsgroup.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
> "Learner" <pra...@.gmail.com> wrote in message
> news:d505cae9-2eb0-4b27-9e1b-2a3a3fbab7c2@.o6g2000hsd.googlegroups.com...
>
> > Hi,
> > Our current production database server is SQL Server 2000 and it is
> > running on Windows 2000 server.
> > Now as part of the upgrade we bouht a new machine and installed
> > Windows 2003 Server and SQL Server 2005 on it.
> > Now our idea is to move the databases from the current production to
> > the new SQL Server 2005. 1).How do we do that? Is it just do a
> > restore
> > of the most recent back up of a particular database on the new new
> > SQL
> > Server 2005?
> > 2).Also we are thinking to syncronize the data between the current
> > production server and the new SQL Server 2005. So that at one point
> > it
> > thins are ok then we could point the web app to the new SQL Server
> > 2005 which is currently pointing to the current production SQL
> > Server .
> > In other words how do make transition from the current SQL Server
> > 2000
> > to our new SQL Server 2005?
> > Can any body suggest me a starting point on this on how do we do
> > this?
> > Your help is hihly appreciated.
> > Thanks,
> > -L- Hide quoted text -
> - Show quoted text -
Hi,
Thank you for the high level suggestions and all the links that you
uys have provided. I will to go through one after the other I guess I
shold be fine with these links.
Kelly - I just wanted a quick start on this issue so I posted in two
different locations of SQL Server. I am sorry for any inconvenience.
By the way I din't know that we could post in one location and have it
appeared in multiple related groups. How do we do that?
Ben - The link you provided should help me with a proper planing to
implement the upgrade process.
Thank You,
-L|||>By the way I din't know that we could post in one location and have it
>appeared in multiple related groups. How do we do that?
Yup a lot of people don't realize it so that is why I posted the message. If
you are using OE just click on the NewsGroups Icon at the top of the message
and you can choose additional groups. Then replies go to all at once.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Learner" <pradev@.gmail.com> wrote in message
news:d71c424b-7a7c-40bb-bddf-dc4c94f279cd@.i29g2000prf.googlegroups.com...
> On Nov 28, 1:00 pm, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
> wrote:
>> Please don't post independently in separate newsgroups. You can add
>> multiple newsgroups to the header and then all the answers appear as one.
>> See my reply in the other newsgroup.
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>> "Learner" <pra...@.gmail.com> wrote in message
>> news:d505cae9-2eb0-4b27-9e1b-2a3a3fbab7c2@.o6g2000hsd.googlegroups.com...
>>
>> > Hi,
>> > Our current production database server is SQL Server 2000 and it is
>> > running on Windows 2000 server.
>> > Now as part of the upgrade we bouht a new machine and installed
>> > Windows 2003 Server and SQL Server 2005 on it.
>> > Now our idea is to move the databases from the current production to
>> > the new SQL Server 2005. 1).How do we do that? Is it just do a
>> > restore
>> > of the most recent back up of a particular database on the new new
>> > SQL
>> > Server 2005?
>> > 2).Also we are thinking to syncronize the data between the current
>> > production server and the new SQL Server 2005. So that at one point
>> > it
>> > thins are ok then we could point the web app to the new SQL Server
>> > 2005 which is currently pointing to the current production SQL
>> > Server .
>> > In other words how do make transition from the current SQL Server
>> > 2000
>> > to our new SQL Server 2005?
>> > Can any body suggest me a starting point on this on how do we do
>> > this?
>> > Your help is hihly appreciated.
>> > Thanks,
>> > -L- Hide quoted text -
>> - Show quoted text -
> Hi,
> Thank you for the high level suggestions and all the links that you
> uys have provided. I will to go through one after the other I guess I
> shold be fine with these links.
> Kelly - I just wanted a quick start on this issue so I posted in two
> different locations of SQL Server. I am sorry for any inconvenience.
> By the way I din't know that we could post in one location and have it
> appeared in multiple related groups. How do we do that?
> Ben - The link you provided should help me with a proper planing to
> implement the upgrade process.
> Thank You,
> -L|||On Nov 28, 2:53 pm, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
wrote:
> >By the way I din't know that we could post in one location and have it
> >appeared in multiple related groups. How do we do that?
> Yup a lot of people don't realize it so that is why I posted the message. If
> you are using OE just click on the NewsGroups Icon at the top of the message
> and you can choose additional groups. Then replies go to all at once.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
> "Learner" <pra...@.gmail.com> wrote in message
> news:d71c424b-7a7c-40bb-bddf-dc4c94f279cd@.i29g2000prf.googlegroups.com...
>
> > On Nov 28, 1:00 pm, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
> > wrote:
> >> Please don't post independently in separate newsgroups. You can add
> >> multiple newsgroups to the header and then all the answers appear as one.
> >> See my reply in the other newsgroup.
> >> --
> >> Andrew J. Kelly SQL MVP
> >> Solid Quality Mentors
> >> "Learner" <pra...@.gmail.com> wrote in message
> >>news:d505cae9-2eb0-4b27-9e1b-2a3a3fbab7c2@.o6g2000hsd.googlegroups.com...
> >> > Hi,
> >> > Our current production database server is SQL Server 2000 and it is
> >> > running on Windows 2000 server.
> >> > Now as part of the upgrade we bouht a new machine and installed
> >> > Windows 2003 Server and SQL Server 2005 on it.
> >> > Now our idea is to move the databases from the current production to
> >> > the new SQL Server 2005. 1).How do we do that? Is it just do a
> >> > restore
> >> > of the most recent back up of a particular database on the new new
> >> > SQL
> >> > Server 2005?
> >> > 2).Also we are thinking to syncronize the data between the current
> >> > production server and the new SQL Server 2005. So that at one point
> >> > it
> >> > thins are ok then we could point the web app to the new SQL Server
> >> > 2005 which is currently pointing to the current production SQL
> >> > Server .
> >> > In other words how do make transition from the current SQL Server
> >> > 2000
> >> > to our new SQL Server 2005?
> >> > Can any body suggest me a starting point on this on how do we do
> >> > this?
> >> > Your help is hihly appreciated.
> >> > Thanks,
> >> > -L- Hide quoted text -
> >> - Show quoted text -
> > Hi,
> > Thank you for the high level suggestions and all the links that you
> > uys have provided. I will to go through one after the other I guess I
> > shold be fine with these links.
> > Kelly - I just wanted a quick start on this issue so I posted in two
> > different locations of SQL Server. I am sorry for any inconvenience.
> > By the way I din't know that we could post in one location and have it
> > appeared in multiple related groups. How do we do that?
> > Ben - The link you provided should help me with a proper planing to
> > implement the upgrade process.
> > Thank You,
> > -L- Hide quoted text -
> - Show quoted text -
HI Kelly,
Thanks for taking time to help me out here but I can't find
NewsGroups icon at the top of the any of our messages or on the top of
the message. What are you reffering to when you said if I am using OE?
Thanks,
-L|||OE stands for Outlook Express. If you are using another newsreader or the
web I don't know what it looks like. In OE the top of the page looks similar
to this:
News Server: [SQL Server News
]
(icon) Newsgroups: [
]
(icon) Cc:
[
]
Subject:
[
]
But the bottom line is that you can add more or different newsgroups to the
Newsgroups section seperated by a comma to post to all of them at once.
(icon) Newsgroups: [ microsoft.public.sqlserver.server,
microsoft.public.sqlserver.programming ]
Hope that helps,
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Learner" <pradev@.gmail.com> wrote in message
news:9ee61f2f-7576-4338-a056-d6f628c0e593@.v4g2000hsf.googlegroups.com...
> On Nov 28, 2:53 pm, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
> wrote:
>> >By the way I din't know that we could post in one location and have it
>> >appeared in multiple related groups. How do we do that?
>> Yup a lot of people don't realize it so that is why I posted the message.
>> If
>> you are using OE just click on the NewsGroups Icon at the top of the
>> message
>> and you can choose additional groups. Then replies go to all at once.
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>> "Learner" <pra...@.gmail.com> wrote in message
>> news:d71c424b-7a7c-40bb-bddf-dc4c94f279cd@.i29g2000prf.googlegroups.com...
>>
>> > On Nov 28, 1:00 pm, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
>> > wrote:
>> >> Please don't post independently in separate newsgroups. You can add
>> >> multiple newsgroups to the header and then all the answers appear as
>> >> one.
>> >> See my reply in the other newsgroup.
>> >> --
>> >> Andrew J. Kelly SQL MVP
>> >> Solid Quality Mentors
>> >> "Learner" <pra...@.gmail.com> wrote in message
>> >>news:d505cae9-2eb0-4b27-9e1b-2a3a3fbab7c2@.o6g2000hsd.googlegroups.com...
>> >> > Hi,
>> >> > Our current production database server is SQL Server 2000 and it is
>> >> > running on Windows 2000 server.
>> >> > Now as part of the upgrade we bouht a new machine and installed
>> >> > Windows 2003 Server and SQL Server 2005 on it.
>> >> > Now our idea is to move the databases from the current production to
>> >> > the new SQL Server 2005. 1).How do we do that? Is it just do a
>> >> > restore
>> >> > of the most recent back up of a particular database on the new new
>> >> > SQL
>> >> > Server 2005?
>> >> > 2).Also we are thinking to syncronize the data between the current
>> >> > production server and the new SQL Server 2005. So that at one point
>> >> > it
>> >> > thins are ok then we could point the web app to the new SQL Server
>> >> > 2005 which is currently pointing to the current production SQL
>> >> > Server .
>> >> > In other words how do make transition from the current SQL Server
>> >> > 2000
>> >> > to our new SQL Server 2005?
>> >> > Can any body suggest me a starting point on this on how do we do
>> >> > this?
>> >> > Your help is hihly appreciated.
>> >> > Thanks,
>> >> > -L- Hide quoted text -
>> >> - Show quoted text -
>> > Hi,
>> > Thank you for the high level suggestions and all the links that you
>> > uys have provided. I will to go through one after the other I guess I
>> > shold be fine with these links.
>> > Kelly - I just wanted a quick start on this issue so I posted in two
>> > different locations of SQL Server. I am sorry for any inconvenience.
>> > By the way I din't know that we could post in one location and have it
>> > appeared in multiple related groups. How do we do that?
>> > Ben - The link you provided should help me with a proper planing to
>> > implement the upgrade process.
>> > Thank You,
>> > -L- Hide quoted text -
>> - Show quoted text -
> HI Kelly,
> Thanks for taking time to help me out here but I can't find
> NewsGroups icon at the top of the any of our messages or on the top of
> the message. What are you reffering to when you said if I am using OE?
> Thanks,
> -L|||On Nov 29, 9:32 am, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
wrote:
> OE stands for Outlook Express. If you are using another newsreader or the
> web I don't know what it looks like. In OE the top of the page looks similar
> to this:
> News Server: [SQL Server News
> ]
> (icon) Newsgroups: [
> ]
> (icon) Cc:
> [
> ]
> Subject:
> [
> ]
> But the bottom line is that you can add more or different newsgroups to the
> Newsgroups section seperated by a comma to post to all of them at once.
> (icon) Newsgroups: [ microsoft.public.sqlserver.server,
> microsoft.public.sqlserver.programming ]
> Hope that helps,
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
> "Learner" <pra...@.gmail.com> wrote in message
> news:9ee61f2f-7576-4338-a056-d6f628c0e593@.v4g2000hsf.googlegroups.com...
>
> > On Nov 28, 2:53 pm, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
> > wrote:
> >> >By the way I din't know that we could post in one location and have it
> >> >appeared in multiple related groups. How do we do that?
> >> Yup a lot of people don't realize it so that is why I posted the message.
> >> If
> >> you are using OE just click on the NewsGroups Icon at the top of the
> >> message
> >> and you can choose additional groups. Then replies go to all at once.
> >> --
> >> Andrew J. Kelly SQL MVP
> >> Solid Quality Mentors
> >> "Learner" <pra...@.gmail.com> wrote in message
> >>news:d71c424b-7a7c-40bb-bddf-dc4c94f279cd@.i29g2000prf.googlegroups.com...
> >> > On Nov 28, 1:00 pm, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
> >> > wrote:
> >> >> Please don't post independently in separate newsgroups. You can add
> >> >> multiple newsgroups to the header and then all the answers appear as
> >> >> one.
> >> >> See my reply in the other newsgroup.
> >> >> --
> >> >> Andrew J. Kelly SQL MVP
> >> >> Solid Quality Mentors
> >> >> "Learner" <pra...@.gmail.com> wrote in message
> >> >>news:d505cae9-2eb0-4b27-9e1b-2a3a3fbab7c2@.o6g2000hsd.googlegroups.com...
> >> >> > Hi,
> >> >> > Our current production database server is SQL Server 2000 and it is
> >> >> > running on Windows 2000 server.
> >> >> > Now as part of the upgrade we bouht a new machine and installed
> >> >> > Windows 2003 Server and SQL Server 2005 on it.
> >> >> > Now our idea is to move the databases from the current production to
> >> >> > the new SQL Server 2005. 1).How do we do that? Is it just do a
> >> >> > restore
> >> >> > of the most recent back up of a particular database on the new new
> >> >> > SQL
> >> >> > Server 2005?
> >> >> > 2).Also we are thinking to syncronize the data between the current
> >> >> > production server and the new SQL Server 2005. So that at one point
> >> >> > it
> >> >> > thins are ok then we could point the web app to the new SQL Server
> >> >> > 2005 which is currently pointing to the current production SQL
> >> >> > Server .
> >> >> > In other words how do make transition from the current SQL Server
> >> >> > 2000
> >> >> > to our new SQL Server 2005?
> >> >> > Can any body suggest me a starting point on this on how do we do
> >> >> > this?
> >> >> > Your help is hihly appreciated.
> >> >> > Thanks,
> >> >> > -L- Hide quoted text -
> >> >> - Show quoted text -
> >> > Hi,
> >> > Thank you for the high level suggestions and all the links that you
> >> > uys have provided. I will to go through one after the other I guess I
> >> > shold be fine with these links.
> >> > Kelly - I just wanted a quick start on this issue so I posted in two
> >> > different locations of SQL Server. I am sorry for any inconvenience.
> >> > By the way I din't know that we could post in one location and have it
> >> > appeared in multiple related groups. How do we do that?
> >> > Ben - The link you provided should help me with a proper planing to
> >> > implement the upgrade process.
> >> > Thank You,
> >> > -L- Hide quoted text -
> >> - Show quoted text -
> > HI Kelly,
> > Thanks for taking time to help me out here but I can't find
> > NewsGroups icon at the top of the any of our messages or on the top of
> > the message. What are you reffering to when you said if I am using OE?
> > Thanks,
> > -L- Hide quoted text -
> - Show quoted text -
Thanks I got it.

Monday, March 12, 2012

Moving SQL 7.0 to New Hardware

Hi,
I've read some articles on the web but none seem to fit my
situation.
We have an application upgrade and at the same time need
to move our SQL 7.0 to new hardware.
The new server will have Windows 2000 and SQL 7.0
installed and then we will upgrade to SQL 2000 at some
point during our application upgrade.
What is the best method of moving our SQL 7.0 databases to
our new hardware?
Thanks in advance.You can either use BACKUP and RESTORE, or sp_detach_db and sp_attach_db.
Make sure you sync users after transferring databases.
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Larry" <sloberman@.email.chop.edu> wrote in message
news:582901c40081$dd8e7ae0$a301280a@.phx.gbl...
> Hi,
> I've read some articles on the web but none seem to fit my
> situation.
> We have an application upgrade and at the same time need
> to move our SQL 7.0 to new hardware.
> The new server will have Windows 2000 and SQL 7.0
> installed and then we will upgrade to SQL 2000 at some
> point during our application upgrade.
> What is the best method of moving our SQL 7.0 databases to
> our new hardware?
> Thanks in advance.

Moving SQL 7.0 to New Hardware

Hi,
I've read some articles on the web but none seem to fit my
situation.
We have an application upgrade and at the same time need
to move our SQL 7.0 to new hardware.
The new server will have Windows 2000 and SQL 7.0
installed and then we will upgrade to SQL 2000 at some
point during our application upgrade.
What is the best method of moving our SQL 7.0 databases to
our new hardware?
Thanks in advance.You can either use BACKUP and RESTORE, or sp_detach_db and sp_attach_db.
Make sure you sync users after transferring databases.
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"Larry" <sloberman@.email.chop.edu> wrote in message
news:582901c40081$dd8e7ae0$a301280a@.phx.gbl...
> Hi,
> I've read some articles on the web but none seem to fit my
> situation.
> We have an application upgrade and at the same time need
> to move our SQL 7.0 to new hardware.
> The new server will have Windows 2000 and SQL 7.0
> installed and then we will upgrade to SQL 2000 at some
> point during our application upgrade.
> What is the best method of moving our SQL 7.0 databases to
> our new hardware?
> Thanks in advance.

Friday, March 9, 2012

Moving servers

I am planing to build a new sql 2000 serevr on a new
server machine, so that I can upgrade the existing servers
to a new spec and have failover clustering.
I plan to copy all the database to the new server using
the copy wizard, this will copy all the SP etc from the
origal server to the new server, but how can you copy 200+
dts packages to this new server without going into each
package and saving it to the new locationHow about this
Transferring DTS Packages
(http://www.sqldts.com/Default.aspx?204)
--
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
"Allan" <penstona@.sitel.co.uk> wrote in message
news:067501c39c73$881c8b50$a101280a@.phx.gbl...
> I am planing to build a new sql 2000 serevr on a new
> server machine, so that I can upgrade the existing servers
> to a new spec and have failover clustering.
> I plan to copy all the database to the new server using
> the copy wizard, this will copy all the SP etc from the
> origal server to the new server, but how can you copy 200+
> dts packages to this new server without going into each
> package and saving it to the new location
>|||Try the DTSBackup tool that is available on SQLDTS.com.
--
Jacco Schalkwijk
SQL Server MVP
"Allan" <penstona@.sitel.co.uk> wrote in message
news:067501c39c73$881c8b50$a101280a@.phx.gbl...
> I am planing to build a new sql 2000 serevr on a new
> server machine, so that I can upgrade the existing servers
> to a new spec and have failover clustering.
> I plan to copy all the database to the new server using
> the copy wizard, this will copy all the SP etc from the
> origal server to the new server, but how can you copy 200+
> dts packages to this new server without going into each
> package and saving it to the new location
>|||SQL Server store DTS packages in MSDB database.
So, if you are going to transfer your DBs from old 2K to a
new 2K Server, you can just make backup/restore operation.
Make sure you transfer MSDB database for the DTS packages.
You also can have a problem with system logins.
Take a look at this article about this issue:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;246133&Product=sql
Regards.
---
All information provided above AS IS.
>--Original Message--
>I am planing to build a new sql 2000 serevr on a new
>server machine, so that I can upgrade the existing
servers
>to a new spec and have failover clustering.
>I plan to copy all the database to the new server using
>the copy wizard, this will copy all the SP etc from the
>origal server to the new server, but how can you copy
200+
>dts packages to this new server without going into each
>package and saving it to the new location
>.
>

Saturday, February 25, 2012

Moving objects from 1 SQL Server to another

Greetings one and all,

I hope some here can help me.

We are currently running SQL Server 2000 on 2 different servers. The first server was an upgrade from SQL 7 so the data, etc are in a directory named MSSQL7. The second sever is newer and larger (Disk and Memeory) and was a straight install, so the data is in MSSQL.

I am trying to move everything from the old server to the new one. The databases are easy as well as the users. I can not get my DTS packages, DB Maintenance, and SQL Server Agent jobs from the old one to the new one.

Any ideas?? We are running out of room on the old server and need to get this moved over asap.

I look forward to hearing from someone.

RayFor the SQL Server Agent jobs (and DB Maintenance as well, as they are all created as Jobs I believe) you can right click in the Enterprise Managers Management/Jobs Tree and select All Tasks/Generate SQL Script

Hope this helps.

Quote:

Originally Posted by rdfanta

Greetings one and all,

I hope some here can help me.

Any ideas?? We are running out of room on the old server and need to get this moved over asap.

I look forward to hearing from someone.

Ray

|||Mr Byte,

Thanks for the info. The only Item that gives me that option is the SQL Server Agent Jobs. But I get an error when trying to run the script because the DB Maintenance Job does not exist.

For the DTS Packages, I am trying to save them as Structured Storage files or Visual Basic files. But I have not figured out how to read them back in

Ray

Moving msdb and model database to a standby machine

Hi
We are planning to do a hardware upgrade for our SQL 2000 STD edition.
I have to activate my standby database.
I am only restoring the standby for my Production database (tg)
But now I need to copy model,msdb DB also to get the jobs.
Can I drop and create the DB from Production using restore methods.
Please let me know.
Tks
Mangesh
"But now I need to copy model..." WHY? model is empty database, template for
new database...
you can restore msdb if you use same version (and sp) and collation on
standby server
1. stop sql agent
2. restore msdb
3. start agent and check agent error log...
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Mangesh Deshpande" wrote:

> Hi
> We are planning to do a hardware upgrade for our SQL 2000 STD edition.
> I have to activate my standby database.
> I am only restoring the standby for my Production database (tg)
> But now I need to copy model,msdb DB also to get the jobs.
> Can I drop and create the DB from Production using restore methods.
> Please let me know.
> Tks
> Mangesh

Moving msdb and model database to a standby machine

Hi
We are planning to do a hardware upgrade for our SQL 2000 STD edition.
I have to activate my standby database.
I am only restoring the standby for my Production database (tg)
But now I need to copy model,msdb DB also to get the jobs.
Can I drop and create the DB from Production using restore methods.
Please let me know.
Tks
Mangesh"But now I need to copy model..." WHY? model is empty database, template for
new database...
you can restore msdb if you use same version (and sp) and collation on
standby server
1. stop sql agent
2. restore msdb
3. start agent and check agent error log...
--
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Mangesh Deshpande" wrote:
> Hi
> We are planning to do a hardware upgrade for our SQL 2000 STD edition.
> I have to activate my standby database.
> I am only restoring the standby for my Production database (tg)
> But now I need to copy model,msdb DB also to get the jobs.
> Can I drop and create the DB from Production using restore methods.
> Please let me know.
> Tks
> Mangesh

Moving msdb and model database to a standby machine

Hi
We are planning to do a hardware upgrade for our SQL 2000 STD edition.
I have to activate my standby database.
I am only restoring the standby for my Production database (tg)
But now I need to copy model,msdb DB also to get the jobs.
Can I drop and create the DB from Production using restore methods.
Please let me know.
Tks
Mangesh"But now I need to copy model..." WHY? model is empty database, template fo
r
new database...
you can restore msdb if you use same version (and sp) and collation on
standby server
1. stop sql agent
2. restore msdb
3. start agent and check agent error log...
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Mangesh Deshpande" wrote:

> Hi
> We are planning to do a hardware upgrade for our SQL 2000 STD edition.
> I have to activate my standby database.
> I am only restoring the standby for my Production database (tg)
> But now I need to copy model,msdb DB also to get the jobs.
> Can I drop and create the DB from Production using restore methods.
> Please let me know.
> Tks
> Mangesh

Monday, February 20, 2012

Moving Logins from 6.5 to 2000

Hi,
The method to transfer the logins with the password from SQL Server 6.5 to SQL Server 2000 is
to upgrade the databases using "upgrade wizard". There is no documented way to move logins with password using scripts.
But there is undocumented method method to do this. see the below link. I have never tried this.
http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
FOR SQL 7 and SQL 2000 servers you can read the below article to transfer logins.
http://support.microsoft.com/?kbid=246133
Thanks
Hari
SQL Server MVP
____________________________________
Newbie Wrote:
Hello all,
I need to move over all the users in 6.5 into 2000, but when i created the
script to create the logins, the passwords came in as null into the new 2000
db. How do I birng over the passwords from 6.5 into the new 2000? Any help
is appreciated. Thanks in advance.
--
New SQL Server DBA
Sent via SreeSharp NewsReader http://www.SreeSharp.comThanks for the advise. How do I get this upgrade wizard? Thanks.
"Hari Prasad" wrote:
> Hi,
> The method to transfer the logins with the password from SQL Server 6.5 to SQL Server 2000 is
> to upgrade the databases using "upgrade wizard". There is no documented way to move logins with password using scripts.
> But there is undocumented method method to do this. see the below link. I have never tried this.
> http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
>
> FOR SQL 7 and SQL 2000 servers you can read the below article to transfer logins.
> http://support.microsoft.com/?kbid=246133
>
> Thanks
> Hari
> SQL Server MVP
> ____________________________________
> Newbie Wrote:
> Hello all,
> I need to move over all the users in 6.5 into 2000, but when i created the
> script to create the logins, the passwords came in as null into the new 2000
> db. How do I birng over the passwords from 6.5 into the new 2000? Any help
> is appreciated. Thanks in advance.
> --
> New SQL Server DBA
>
>
>
> Sent via SreeSharp NewsReader http://www.SreeSharp.com
>|||Hi,
This comes automatically when you install SQL Server 2000. After
installation see the SQL Server program groups.
Thanks
Hari
SQL Server MVP
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:C222A6D0-0AF9-4F6E-88D8-AA280AE1E2CF@.microsoft.com...
> Thanks for the advise. How do I get this upgrade wizard? Thanks.
> "Hari Prasad" wrote:
>> Hi,
>> The method to transfer the logins with the password from SQL Server 6.5
>> to SQL Server 2000 is
>> to upgrade the databases using "upgrade wizard". There is no documented
>> way to move logins with password using scripts.
>> But there is undocumented method method to do this. see the below link. I
>> have never tried this.
>> http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
>>
>> FOR SQL 7 and SQL 2000 servers you can read the below article to transfer
>> logins.
>> http://support.microsoft.com/?kbid=246133
>>
>> Thanks
>> Hari
>> SQL Server MVP
>> ____________________________________
>> Newbie Wrote:
>> Hello all,
>> I need to move over all the users in 6.5 into 2000, but when i created
>> the
>> script to create the logins, the passwords came in as null into the new
>> 2000
>> db. How do I birng over the passwords from 6.5 into the new 2000? Any
>> help
>> is appreciated. Thanks in advance.
>> --
>> New SQL Server DBA
>>
>>
>>
>> Sent via SreeSharp NewsReader http://www.SreeSharp.com

Monday, March 19, 2012

Moving SQL Server 2000 to SQL Server 2005 - Need suggestions onsyncronization of data betw

Moving SQL Server 2000 to SQL Server 2005 - Need suggestions on

Monday, March 12, 2012

Moving SQL 7.0 to New Hardware

Moving SQL 7.0 to New Hardware

Friday, March 9, 2012

Moving servers

Saturday, February 25, 2012

Moving objects from 1 SQL Server to another

Moving msdb and model database to a standby machine

Moving msdb and model database to a standby machine

Moving msdb and model database to a standby machine

Monday, February 20, 2012

Moving Logins from 6.5 to 2000

Moving Log Files

Blog Archive

About Me