Moving to hosted dedicated server - Cannot open database requested in login

Hello all,
I hope someone can help with my current issue as i have now spent the last 8hours trying to solve it! Here goes...
I am currently moving all my websites from our in house set up to a FASTHOSTSdedicated server. Our in house set up consists of separate server for weband data and works well even with my recent foray into .Net sites.
I have just moved the most recent of my .Net sites(http://www.alfadealerads.co.uk/home.aspx) to the FASTHOSTS server and cannotget the site to connect to the database (this has also been installed on theFASTHOSTS server). One of the pages that connects to the DB ishttp://www.alfadealerads.co.uk/links.aspx, where i am getting the error..
System.Data.SqlClient.SqlException: Cannot open database requested in login'MasseratiChauffeurDrive'. Login fails.
Login failed for user 'lateral'.
This DB has been restored from back up from the original DB. I haverecreated the user name on the new SQL server and added it to the new DBalso. I am using a webconfig to connect to the DB, the exact same onethat works on my current live server(http://www.maseratichauffeurdrive.com/home.aspx) only with the obvious changeto the SQL server name.
The only difference i can see in the 2 setups is that the new one has both thewebserver and the SQL server on the one machine and that machine uses domains.
My current in house setup does not use domains and as mentioned before web anddate are 2 separate servers.
Can anyone help? Or even understand what the hell i have written? lol
Thanks in advance

I know the backup and restore wizard can restore everything including login so the question is why do you have to recreate the login after the restore. I would do a fresh restore and delete the current database and try to login without any changes. Hope this helps.|||

TheFIsh wrote:

System.Data.SqlClient.SqlException: Cannot open database requested in login'MasseratiChauffeurDrive'. Login fails.
Login failed for user 'lateral'.
This DB has been restored from back up from the original DB. I haverecreated the user name on the new SQL server and added it to the new DBalso. I am using a webconfig to connect to the DB, the exact same onethat works on my current live server(http://www.maseratichauffeurdrive.com/home.aspx) only with the obvious changeto the SQL server name.

When you created the new login account, did you check the "SQL ServerAuthentication" radio button instead of leaving it on the default"Windows Authentication"?
|||Thanks for the feedback.
When you created the new login account, did you check the "SQL ServerAuthentication" radio button instead of leaving it on the default"Windows Authentication"?
Yes i checked the SQL server authentication and specified a password. Still not solved.
Cheers,
Stephen

moving SSAS 2005 database to another drive

Hello,

how can I move the SSAS 2005 database to another drive ? The reason is, I′m running out of space on the current drive.

Thanks a lot for an answer.

Hi,

You can change the Data folder for AS2005, to move all the databases to another location (you cannot have separate locations for databases on the same AS2005 instance). To do that:

1. use the server's properties dialog to specify the new path (from SQL Management Studio, connect to AS2005, right click on the server, Properties, DataDir property) (the change will not become effective immediately, no actual data will be moved)

2. stop AS2005

3. move the Data directory to the drive you want

4. restart AS2005

sql

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

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
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" <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...
>
>
>
>
>
>
> - 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:
> 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:
> 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...
>
>
>
>
>
>
>
>
>
>
>
> - 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:
> 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...
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> - Show quoted text -
Thanks I got it.

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.

Moving SQL Server 2000 to a new Virtual Server

Hi,
I am moving the default instance of a SQL Server 2000 to a ESX Server
running on VMWare. Below are the specifications:
Current Server:
SQL Server 2000 Enterprise Edition Version 8.00.2187
Windows Advanced Server 2000 SP4
Intel Pentium III 1400 MHz
4 GB RAM
/3 GB switch enabled in boot.ini
AWE not enabled and SQL Server using a maximum of 3 GB of RAM.
Target Server:
SQL Server 2000 Enterprise Edition Version 8.00.2187
Windows Server 2003 Enterprise Edition SP2
Intel Xeon X7350 2.93 GHz
3.75 GB RAM
/PAE 3 GB switch enabled in boot.ini
AWE not enabled
The target server is running on VMWare and we will be adding more memory to
it if it is needed in the future. What AWE setting should I be using on the
target machine?Your target BOOT.INI has the /PAE switch enabled. Remove it and use /3GB.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"ronnie" <ronnie@.discussions.microsoft.com> wrote in message
news:C14D97C4-6190-4632-9A7B-D619F992B5CB@.microsoft.com...
Hi,
I am moving the default instance of a SQL Server 2000 to a ESX Server
running on VMWare. Below are the specifications:
Current Server:
SQL Server 2000 Enterprise Edition Version 8.00.2187
Windows Advanced Server 2000 SP4
Intel Pentium III 1400 MHz
4 GB RAM
/3 GB switch enabled in boot.ini
AWE not enabled and SQL Server using a maximum of 3 GB of RAM.
Target Server:
SQL Server 2000 Enterprise Edition Version 8.00.2187
Windows Server 2003 Enterprise Edition SP2
Intel Xeon X7350 2.93 GHz
3.75 GB RAM
/PAE 3 GB switch enabled in boot.ini
AWE not enabled
The target server is running on VMWare and we will be adding more memory to
it if it is needed in the future. What AWE setting should I be using on the
target machine?|||Thanks a lot Tom for the quick response. Can you please explain the reason
why you want to have that change so that I can have a better understanding of
what's going on? Also, the target server has a Windows 2003 server in
comparison to the current server that is running on Windows 2000 server.
What would happen if the AWE is enabled? Thanks in advance.
"Tom Moreau" wrote:
> Your target BOOT.INI has the /PAE switch enabled. Remove it and use /3GB.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "ronnie" <ronnie@.discussions.microsoft.com> wrote in message
> news:C14D97C4-6190-4632-9A7B-D619F992B5CB@.microsoft.com...
> Hi,
> I am moving the default instance of a SQL Server 2000 to a ESX Server
> running on VMWare. Below are the specifications:
> Current Server:
> SQL Server 2000 Enterprise Edition Version 8.00.2187
> Windows Advanced Server 2000 SP4
> Intel Pentium III 1400 MHz
> 4 GB RAM
> /3 GB switch enabled in boot.ini
> AWE not enabled and SQL Server using a maximum of 3 GB of RAM.
>
> Target Server:
> SQL Server 2000 Enterprise Edition Version 8.00.2187
> Windows Server 2003 Enterprise Edition SP2
> Intel Xeon X7350 2.93 GHz
> 3.75 GB RAM
> /PAE 3 GB switch enabled in boot.ini
> AWE not enabled
> The target server is running on VMWare and we will be adding more memory to
> it if it is needed in the future. What AWE setting should I be using on the
> target machine?
>|||What was referring to was this:
"/PAE 3 GB switch enabled in boot.ini"
It is self-contradictory. /PAE is not 3GB.
Also, you don't have enough memory to take advantage of AWE.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"ronnie" <ronnie@.discussions.microsoft.com> wrote in message
news:FCBE95A4-E3E6-4FCE-9548-090B812D9EB6@.microsoft.com...
Thanks a lot Tom for the quick response. Can you please explain the reason
why you want to have that change so that I can have a better understanding
of
what's going on? Also, the target server has a Windows 2003 server in
comparison to the current server that is running on Windows 2000 server.
What would happen if the AWE is enabled? Thanks in advance.
"Tom Moreau" wrote:
> Your target BOOT.INI has the /PAE switch enabled. Remove it and use /3GB.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "ronnie" <ronnie@.discussions.microsoft.com> wrote in message
> news:C14D97C4-6190-4632-9A7B-D619F992B5CB@.microsoft.com...
> Hi,
> I am moving the default instance of a SQL Server 2000 to a ESX Server
> running on VMWare. Below are the specifications:
> Current Server:
> SQL Server 2000 Enterprise Edition Version 8.00.2187
> Windows Advanced Server 2000 SP4
> Intel Pentium III 1400 MHz
> 4 GB RAM
> /3 GB switch enabled in boot.ini
> AWE not enabled and SQL Server using a maximum of 3 GB of RAM.
>
> Target Server:
> SQL Server 2000 Enterprise Edition Version 8.00.2187
> Windows Server 2003 Enterprise Edition SP2
> Intel Xeon X7350 2.93 GHz
> 3.75 GB RAM
> /PAE 3 GB switch enabled in boot.ini
> AWE not enabled
> The target server is running on VMWare and we will be adding more memory
> to
> it if it is needed in the future. What AWE setting should I be using on
> the
> target machine?
>|||I just got to know that the RAM is going to be increased to 6 GB on the
target server before it goes into Production. How does it affect the /PAE or
the /3GB switch in boot.ini file and the AWE enabled / disabled on SQL Server?
Thanks in advance.
"ronnie" wrote:
> Thanks a lot Tom for the quick response. Can you please explain the reason
> why you want to have that change so that I can have a better understanding of
> what's going on? Also, the target server has a Windows 2003 server in
> comparison to the current server that is running on Windows 2000 server.
> What would happen if the AWE is enabled? Thanks in advance.
> "Tom Moreau" wrote:
> > Your target BOOT.INI has the /PAE switch enabled. Remove it and use /3GB.
> >
> > --
> > Tom
> >
> > ----
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > SQL Server MVP
> > Toronto, ON Canada
> > https://mvp.support.microsoft.com/profile/Tom.Moreau
> >
> >
> > "ronnie" <ronnie@.discussions.microsoft.com> wrote in message
> > news:C14D97C4-6190-4632-9A7B-D619F992B5CB@.microsoft.com...
> > Hi,
> >
> > I am moving the default instance of a SQL Server 2000 to a ESX Server
> > running on VMWare. Below are the specifications:
> >
> > Current Server:
> >
> > SQL Server 2000 Enterprise Edition Version 8.00.2187
> > Windows Advanced Server 2000 SP4
> > Intel Pentium III 1400 MHz
> > 4 GB RAM
> > /3 GB switch enabled in boot.ini
> > AWE not enabled and SQL Server using a maximum of 3 GB of RAM.
> >
> >
> > Target Server:
> >
> > SQL Server 2000 Enterprise Edition Version 8.00.2187
> > Windows Server 2003 Enterprise Edition SP2
> > Intel Xeon X7350 2.93 GHz
> > 3.75 GB RAM
> > /PAE 3 GB switch enabled in boot.ini
> > AWE not enabled
> >
> > The target server is running on VMWare and we will be adding more memory to
> > it if it is needed in the future. What AWE setting should I be using on the
> > target machine?
> >
> >|||That's different. In That case, I'd turn on both - once you get the extra
memory. Above 12GB, remove the /3GB switch:
http://groups.google.ca/group/microsoft.public.sqlserver.clustering/browse_thread/thread/5eef281ae5d7ff59/0e83b85ef5b91530?hl=en&lnk=st&q=pae+3gb+hiten#0e83b85ef5b91530
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"ronnie" <ronnie@.discussions.microsoft.com> wrote in message
news:051D8B41-A6F2-49FA-93A4-4DE697956DEC@.microsoft.com...
I just got to know that the RAM is going to be increased to 6 GB on the
target server before it goes into Production. How does it affect the /PAE or
the /3GB switch in boot.ini file and the AWE enabled / disabled on SQL
Server?
Thanks in advance.
"ronnie" wrote:
> Thanks a lot Tom for the quick response. Can you please explain the reason
> why you want to have that change so that I can have a better understanding
> of
> what's going on? Also, the target server has a Windows 2003 server in
> comparison to the current server that is running on Windows 2000 server.
> What would happen if the AWE is enabled? Thanks in advance.
> "Tom Moreau" wrote:
> > Your target BOOT.INI has the /PAE switch enabled. Remove it and use
> > /3GB.
> >
> > --
> > Tom
> >
> > ----
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > SQL Server MVP
> > Toronto, ON Canada
> > https://mvp.support.microsoft.com/profile/Tom.Moreau
> >
> >
> > "ronnie" <ronnie@.discussions.microsoft.com> wrote in message
> > news:C14D97C4-6190-4632-9A7B-D619F992B5CB@.microsoft.com...
> > Hi,
> >
> > I am moving the default instance of a SQL Server 2000 to a ESX Server
> > running on VMWare. Below are the specifications:
> >
> > Current Server:
> >
> > SQL Server 2000 Enterprise Edition Version 8.00.2187
> > Windows Advanced Server 2000 SP4
> > Intel Pentium III 1400 MHz
> > 4 GB RAM
> > /3 GB switch enabled in boot.ini
> > AWE not enabled and SQL Server using a maximum of 3 GB of RAM.
> >
> >
> > Target Server:
> >
> > SQL Server 2000 Enterprise Edition Version 8.00.2187
> > Windows Server 2003 Enterprise Edition SP2
> > Intel Xeon X7350 2.93 GHz
> > 3.75 GB RAM
> > /PAE 3 GB switch enabled in boot.ini
> > AWE not enabled
> >
> > The target server is running on VMWare and we will be adding more memory
> > to
> > it if it is needed in the future. What AWE setting should I be using on
> > the
> > target machine?
> >
> >|||Hi Tom,
I have put in both the /PAE and /3GB switches as you suggested. Now the SQL
Server is only using 3GB of memory. I want the SQL server to use 5 GB out of
6 GB of memory and leave the 1 GB memory for the OS. How can I achieve this?
Thanks in advance.
"Tom Moreau" wrote:
> That's different. In That case, I'd turn on both - once you get the extra
> memory. Above 12GB, remove the /3GB switch:
> http://groups.google.ca/group/microsoft.public.sqlserver.clustering/browse_thread/thread/5eef281ae5d7ff59/0e83b85ef5b91530?hl=en&lnk=st&q=pae+3gb+hiten#0e83b85ef5b91530
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "ronnie" <ronnie@.discussions.microsoft.com> wrote in message
> news:051D8B41-A6F2-49FA-93A4-4DE697956DEC@.microsoft.com...
> I just got to know that the RAM is going to be increased to 6 GB on the
> target server before it goes into Production. How does it affect the /PAE or
> the /3GB switch in boot.ini file and the AWE enabled / disabled on SQL
> Server?
> Thanks in advance.
> "ronnie" wrote:
> > Thanks a lot Tom for the quick response. Can you please explain the reason
> > why you want to have that change so that I can have a better understanding
> > of
> > what's going on? Also, the target server has a Windows 2003 server in
> > comparison to the current server that is running on Windows 2000 server.
> >
> > What would happen if the AWE is enabled? Thanks in advance.
> >
> > "Tom Moreau" wrote:
> >
> > > Your target BOOT.INI has the /PAE switch enabled. Remove it and use
> > > /3GB.
> > >
> > > --
> > > Tom
> > >
> > > ----
> > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > > SQL Server MVP
> > > Toronto, ON Canada
> > > https://mvp.support.microsoft.com/profile/Tom.Moreau
> > >
> > >
> > > "ronnie" <ronnie@.discussions.microsoft.com> wrote in message
> > > news:C14D97C4-6190-4632-9A7B-D619F992B5CB@.microsoft.com...
> > > Hi,
> > >
> > > I am moving the default instance of a SQL Server 2000 to a ESX Server
> > > running on VMWare. Below are the specifications:
> > >
> > > Current Server:
> > >
> > > SQL Server 2000 Enterprise Edition Version 8.00.2187
> > > Windows Advanced Server 2000 SP4
> > > Intel Pentium III 1400 MHz
> > > 4 GB RAM
> > > /3 GB switch enabled in boot.ini
> > > AWE not enabled and SQL Server using a maximum of 3 GB of RAM.
> > >
> > >
> > > Target Server:
> > >
> > > SQL Server 2000 Enterprise Edition Version 8.00.2187
> > > Windows Server 2003 Enterprise Edition SP2
> > > Intel Xeon X7350 2.93 GHz
> > > 3.75 GB RAM
> > > /PAE 3 GB switch enabled in boot.ini
> > > AWE not enabled
> > >
> > > The target server is running on VMWare and we will be adding more memory
> > > to
> > > it if it is needed in the future. What AWE setting should I be using on
> > > the
> > > target machine?
> > >
> > >
>|||Earlier, you said "the RAM is going to be increased to 6 GB". So does the
server have that much physical RAM now? If not, then wait until you have it
before turning on AWE.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"ronnie" <ronnie@.discussions.microsoft.com> wrote in message
news:B23DEDE0-4CE2-4119-BC6F-BB632C5FAE15@.microsoft.com...
Hi Tom,
I have put in both the /PAE and /3GB switches as you suggested. Now the SQL
Server is only using 3GB of memory. I want the SQL server to use 5 GB out of
6 GB of memory and leave the 1 GB memory for the OS. How can I achieve this?
Thanks in advance.
"Tom Moreau" wrote:
> That's different. In That case, I'd turn on both - once you get the extra
> memory. Above 12GB, remove the /3GB switch:
>
http://groups.google.ca/group/microsoft.public.sqlserver.clustering/browse_thread/thread/5eef281ae5d7ff59/0e83b85ef5b91530?hl=en&lnk=st&q=pae+3gb+hiten#0e83b85ef5b91530
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "ronnie" <ronnie@.discussions.microsoft.com> wrote in message
> news:051D8B41-A6F2-49FA-93A4-4DE697956DEC@.microsoft.com...
> I just got to know that the RAM is going to be increased to 6 GB on the
> target server before it goes into Production. How does it affect the /PAE
or
> the /3GB switch in boot.ini file and the AWE enabled / disabled on SQL
> Server?
> Thanks in advance.
> "ronnie" wrote:
> > Thanks a lot Tom for the quick response. Can you please explain the
reason
> > why you want to have that change so that I can have a better
understanding
> > of
> > what's going on? Also, the target server has a Windows 2003 server in
> > comparison to the current server that is running on Windows 2000 server.
> >
> > What would happen if the AWE is enabled? Thanks in advance.
> >
> > "Tom Moreau" wrote:
> >
> > > Your target BOOT.INI has the /PAE switch enabled. Remove it and use
> > > /3GB.
> > >
> > > --
> > > Tom
> > >
> > > ----
> > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > > SQL Server MVP
> > > Toronto, ON Canada
> > > https://mvp.support.microsoft.com/profile/Tom.Moreau
> > >
> > >
> > > "ronnie" <ronnie@.discussions.microsoft.com> wrote in message
> > > news:C14D97C4-6190-4632-9A7B-D619F992B5CB@.microsoft.com...
> > > Hi,
> > >
> > > I am moving the default instance of a SQL Server 2000 to a ESX Server
> > > running on VMWare. Below are the specifications:
> > >
> > > Current Server:
> > >
> > > SQL Server 2000 Enterprise Edition Version 8.00.2187
> > > Windows Advanced Server 2000 SP4
> > > Intel Pentium III 1400 MHz
> > > 4 GB RAM
> > > /3 GB switch enabled in boot.ini
> > > AWE not enabled and SQL Server using a maximum of 3 GB of RAM.
> > >
> > >
> > > Target Server:
> > >
> > > SQL Server 2000 Enterprise Edition Version 8.00.2187
> > > Windows Server 2003 Enterprise Edition SP2
> > > Intel Xeon X7350 2.93 GHz
> > > 3.75 GB RAM
> > > /PAE 3 GB switch enabled in boot.ini
> > > AWE not enabled
> > >
> > > The target server is running on VMWare and we will be adding more
memory
> > > to
> > > it if it is needed in the future. What AWE setting should I be using
on
> > > the
> > > target machine?
> > >
> > >
>|||The server now has 6 GB of RAM. So do I enable AWE and set maximum server
memory to
5 GB with sp_configure? I will leave the /PAE switch in the boot.ini file
and take out the
/3GB switch from it.
"Tom Moreau" wrote:
> Earlier, you said "the RAM is going to be increased to 6 GB". So does the
> server have that much physical RAM now? If not, then wait until you have it
> before turning on AWE.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "ronnie" <ronnie@.discussions.microsoft.com> wrote in message
> news:B23DEDE0-4CE2-4119-BC6F-BB632C5FAE15@.microsoft.com...
> Hi Tom,
> I have put in both the /PAE and /3GB switches as you suggested. Now the SQL
> Server is only using 3GB of memory. I want the SQL server to use 5 GB out of
> 6 GB of memory and leave the 1 GB memory for the OS. How can I achieve this?
> Thanks in advance.
> "Tom Moreau" wrote:
> > That's different. In That case, I'd turn on both - once you get the extra
> > memory. Above 12GB, remove the /3GB switch:
> >
> >
> http://groups.google.ca/group/microsoft.public.sqlserver.clustering/browse_thread/thread/5eef281ae5d7ff59/0e83b85ef5b91530?hl=en&lnk=st&q=pae+3gb+hiten#0e83b85ef5b91530
> >
> > --
> > Tom
> >
> > ----
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > SQL Server MVP
> > Toronto, ON Canada
> > https://mvp.support.microsoft.com/profile/Tom.Moreau
> >
> >
> > "ronnie" <ronnie@.discussions.microsoft.com> wrote in message
> > news:051D8B41-A6F2-49FA-93A4-4DE697956DEC@.microsoft.com...
> > I just got to know that the RAM is going to be increased to 6 GB on the
> > target server before it goes into Production. How does it affect the /PAE
> or
> > the /3GB switch in boot.ini file and the AWE enabled / disabled on SQL
> > Server?
> >
> > Thanks in advance.
> >
> > "ronnie" wrote:
> >
> > > Thanks a lot Tom for the quick response. Can you please explain the
> reason
> > > why you want to have that change so that I can have a better
> understanding
> > > of
> > > what's going on? Also, the target server has a Windows 2003 server in
> > > comparison to the current server that is running on Windows 2000 server.
> > >
> > > What would happen if the AWE is enabled? Thanks in advance.
> > >
> > > "Tom Moreau" wrote:
> > >
> > > > Your target BOOT.INI has the /PAE switch enabled. Remove it and use
> > > > /3GB.
> > > >
> > > > --
> > > > Tom
> > > >
> > > > ----
> > > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > > > SQL Server MVP
> > > > Toronto, ON Canada
> > > > https://mvp.support.microsoft.com/profile/Tom.Moreau
> > > >
> > > >
> > > > "ronnie" <ronnie@.discussions.microsoft.com> wrote in message
> > > > news:C14D97C4-6190-4632-9A7B-D619F992B5CB@.microsoft.com...
> > > > Hi,
> > > >
> > > > I am moving the default instance of a SQL Server 2000 to a ESX Server
> > > > running on VMWare. Below are the specifications:
> > > >
> > > > Current Server:
> > > >
> > > > SQL Server 2000 Enterprise Edition Version 8.00.2187
> > > > Windows Advanced Server 2000 SP4
> > > > Intel Pentium III 1400 MHz
> > > > 4 GB RAM
> > > > /3 GB switch enabled in boot.ini
> > > > AWE not enabled and SQL Server using a maximum of 3 GB of RAM.
> > > >
> > > >
> > > > Target Server:
> > > >
> > > > SQL Server 2000 Enterprise Edition Version 8.00.2187
> > > > Windows Server 2003 Enterprise Edition SP2
> > > > Intel Xeon X7350 2.93 GHz
> > > > 3.75 GB RAM
> > > > /PAE 3 GB switch enabled in boot.ini
> > > > AWE not enabled
> > > >
> > > > The target server is running on VMWare and we will be adding more
> memory
> > > > to
> > > > it if it is needed in the future. What AWE setting should I be using
> on
> > > > the
> > > > target machine?
> > > >
> > > >
> >
> >
>
>|||Yes. Use:
sp_configure 'awe', 1
go
reconfigure with override
go
sp_configure 'max server memory', 5120
go
reconfigure with override
go
Then, stop and start SQL Server.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"ronnie" <ronnie@.discussions.microsoft.com> wrote in message
news:A461C42F-6D8B-4121-A127-7C568F5ECF93@.microsoft.com...
The server now has 6 GB of RAM. So do I enable AWE and set maximum server
memory to
5 GB with sp_configure? I will leave the /PAE switch in the boot.ini file
and take out the
/3GB switch from it.
"Tom Moreau" wrote:
> Earlier, you said "the RAM is going to be increased to 6 GB". So does the
> server have that much physical RAM now? If not, then wait until you have
it
> before turning on AWE.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "ronnie" <ronnie@.discussions.microsoft.com> wrote in message
> news:B23DEDE0-4CE2-4119-BC6F-BB632C5FAE15@.microsoft.com...
> Hi Tom,
> I have put in both the /PAE and /3GB switches as you suggested. Now the
SQL
> Server is only using 3GB of memory. I want the SQL server to use 5 GB out
of
> 6 GB of memory and leave the 1 GB memory for the OS. How can I achieve
this?
> Thanks in advance.
> "Tom Moreau" wrote:
> > That's different. In That case, I'd turn on both - once you get the
extra
> > memory. Above 12GB, remove the /3GB switch:
> >
> >
>
http://groups.google.ca/group/microsoft.public.sqlserver.clustering/browse_thread/thread/5eef281ae5d7ff59/0e83b85ef5b91530?hl=en&lnk=st&q=pae+3gb+hiten#0e83b85ef5b91530
> >
> > --
> > Tom
> >
> > ----
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > SQL Server MVP
> > Toronto, ON Canada
> > https://mvp.support.microsoft.com/profile/Tom.Moreau
> >
> >
> > "ronnie" <ronnie@.discussions.microsoft.com> wrote in message
> > news:051D8B41-A6F2-49FA-93A4-4DE697956DEC@.microsoft.com...
> > I just got to know that the RAM is going to be increased to 6 GB on the
> > target server before it goes into Production. How does it affect the
/PAE
> or
> > the /3GB switch in boot.ini file and the AWE enabled / disabled on SQL
> > Server?
> >
> > Thanks in advance.
> >
> > "ronnie" wrote:
> >
> > > Thanks a lot Tom for the quick response. Can you please explain the
> reason
> > > why you want to have that change so that I can have a better
> understanding
> > > of
> > > what's going on? Also, the target server has a Windows 2003 server in
> > > comparison to the current server that is running on Windows 2000
server.
> > >
> > > What would happen if the AWE is enabled? Thanks in advance.
> > >
> > > "Tom Moreau" wrote:
> > >
> > > > Your target BOOT.INI has the /PAE switch enabled. Remove it and use
> > > > /3GB.
> > > >
> > > > --
> > > > Tom
> > > >
> > > > ----
> > > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > > > SQL Server MVP
> > > > Toronto, ON Canada
> > > > https://mvp.support.microsoft.com/profile/Tom.Moreau
> > > >
> > > >
> > > > "ronnie" <ronnie@.discussions.microsoft.com> wrote in message
> > > > news:C14D97C4-6190-4632-9A7B-D619F992B5CB@.microsoft.com...
> > > > Hi,
> > > >
> > > > I am moving the default instance of a SQL Server 2000 to a ESX
Server
> > > > running on VMWare. Below are the specifications:
> > > >
> > > > Current Server:
> > > >
> > > > SQL Server 2000 Enterprise Edition Version 8.00.2187
> > > > Windows Advanced Server 2000 SP4
> > > > Intel Pentium III 1400 MHz
> > > > 4 GB RAM
> > > > /3 GB switch enabled in boot.ini
> > > > AWE not enabled and SQL Server using a maximum of 3 GB of RAM.
> > > >
> > > >
> > > > Target Server:
> > > >
> > > > SQL Server 2000 Enterprise Edition Version 8.00.2187
> > > > Windows Server 2003 Enterprise Edition SP2
> > > > Intel Xeon X7350 2.93 GHz
> > > > 3.75 GB RAM
> > > > /PAE 3 GB switch enabled in boot.ini
> > > > AWE not enabled
> > > >
> > > > The target server is running on VMWare and we will be adding more
> memory
> > > > to
> > > > it if it is needed in the future. What AWE setting should I be using
> on
> > > > the
> > > > target machine?
> > > >
> > > >
> >
> >
>
>|||Thanks for the quick response, Tom. I have made the changes as you suggested
and
rebooted the server. What I have noticed now in the Task Manager is that
sqlservr.exe is
only using about 120 MB of the 6 GB memory while the CPU usage has gone to
almost
100 % whilst earlier with the /3GB switch in place the memory used by
sqlservr.exe
was almost 2700 MB and the CPU usage was below 10 %.
I haven't heard any user complaints about the system being slow but I am
very puzzled
by this SQL Server behavior.
Current Server configuration:
SQL Server 2000 Enterprise Edition Version 8.00.2187
Windows Server 2003 Enterprise Edition SP2
Intel Xeon X7350 2.93 GHz
6 GB RAM
/PAE enabled in boot.ini
AWE enabled and max server memory is 5GB
(Earlier it had the /3GB switch in boot.ini and AWE disabled)
Old Server configuration:
SQL Server 2000 Enterprise Edition Version 8.00.2187
Windows Advanced Server 2000 SP4
Intel Pentium III 1400 MHz
4 GB RAM
/3 GB switch enabled in boot.ini
AWE not enabled and SQL Server using a maximum of 3 GB of RAM.
"Tom Moreau" wrote:
> Yes. Use:
> sp_configure 'awe', 1
> go
> reconfigure with override
> go
> sp_configure 'max server memory', 5120
> go
> reconfigure with override
> go
> Then, stop and start SQL Server.
>
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "ronnie" <ronnie@.discussions.microsoft.com> wrote in message
> news:A461C42F-6D8B-4121-A127-7C568F5ECF93@.microsoft.com...
> The server now has 6 GB of RAM. So do I enable AWE and set maximum server
> memory to
> 5 GB with sp_configure? I will leave the /PAE switch in the boot.ini file
> and take out the
> /3GB switch from it.
> "Tom Moreau" wrote:
> > Earlier, you said "the RAM is going to be increased to 6 GB". So does the
> > server have that much physical RAM now? If not, then wait until you have
> it
> > before turning on AWE.
> >
> > --
> > Tom
> >
> > ----
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > SQL Server MVP
> > Toronto, ON Canada
> > https://mvp.support.microsoft.com/profile/Tom.Moreau
> >
> >
> > "ronnie" <ronnie@.discussions.microsoft.com> wrote in message
> > news:B23DEDE0-4CE2-4119-BC6F-BB632C5FAE15@.microsoft.com...
> > Hi Tom,
> >
> > I have put in both the /PAE and /3GB switches as you suggested. Now the
> SQL
> > Server is only using 3GB of memory. I want the SQL server to use 5 GB out
> of
> > 6 GB of memory and leave the 1 GB memory for the OS. How can I achieve
> this?
> >
> > Thanks in advance.
> >
> > "Tom Moreau" wrote:
> >
> > > That's different. In That case, I'd turn on both - once you get the
> extra
> > > memory. Above 12GB, remove the /3GB switch:
> > >
> > >
> >
> http://groups.google.ca/group/microsoft.public.sqlserver.clustering/browse_thread/thread/5eef281ae5d7ff59/0e83b85ef5b91530?hl=en&lnk=st&q=pae+3gb+hiten#0e83b85ef5b91530
> > >
> > > --
> > > Tom
> > >
> > > ----
> > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > > SQL Server MVP
> > > Toronto, ON Canada
> > > https://mvp.support.microsoft.com/profile/Tom.Moreau
> > >
> > >
> > > "ronnie" <ronnie@.discussions.microsoft.com> wrote in message
> > > news:051D8B41-A6F2-49FA-93A4-4DE697956DEC@.microsoft.com...
> > > I just got to know that the RAM is going to be increased to 6 GB on the
> > > target server before it goes into Production. How does it affect the
> /PAE
> > or
> > > the /3GB switch in boot.ini file and the AWE enabled / disabled on SQL
> > > Server?
> > >
> > > Thanks in advance.
> > >
> > > "ronnie" wrote:
> > >
> > > > Thanks a lot Tom for the quick response. Can you please explain the
> > reason
> > > > why you want to have that change so that I can have a better
> > understanding
> > > > of
> > > > what's going on? Also, the target server has a Windows 2003 server in
> > > > comparison to the current server that is running on Windows 2000
> server.
> > > >
> > > > What would happen if the AWE is enabled? Thanks in advance.
> > > >
> > > > "Tom Moreau" wrote:
> > > >
> > > > > Your target BOOT.INI has the /PAE switch enabled. Remove it and use
> > > > > /3GB.
> > > > >
> > > > > --
> > > > > Tom
> > > > >
> > > > > ----
> > > > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > > > > SQL Server MVP
> > > > > Toronto, ON Canada
> > > > > https://mvp.support.microsoft.com/profile/Tom.Moreau
> > > > >
> > > > >
> > > > > "ronnie" <ronnie@.discussions.microsoft.com> wrote in message
> > > > > news:C14D97C4-6190-4632-9A7B-D619F992B5CB@.microsoft.com...
> > > > > Hi,
> > > > >
> > > > > I am moving the default instance of a SQL Server 2000 to a ESX
> Server
> > > > > running on VMWare. Below are the specifications:
> > > > >
> > > > > Current Server:
> > > > >
> > > > > SQL Server 2000 Enterprise Edition Version 8.00.2187
> > > > > Windows Advanced Server 2000 SP4
> > > > > Intel Pentium III 1400 MHz
> > > > > 4 GB RAM
> > > > > /3 GB switch enabled in boot.ini
> > > > > AWE not enabled and SQL Server using a maximum of 3 GB of RAM.
> > > > >
> > > > >
> > > > > Target Server:
> > > > >
> > > > > SQL Server 2000 Enterprise Edition Version 8.00.2187
> > > > > Windows Server 2003 Enterprise Edition SP2
> > > > > Intel Xeon X7350 2.93 GHz
> > > > > 3.75 GB RAM
> > > > > /PAE 3 GB switch enabled in boot.ini
> > > > > AWE not enabled
> > > > >
> > > > > The target server is running on VMWare and we will be adding more
> > memory
> > > > > to
> > > > > it if it is needed in the future. What AWE setting should I be using
> > on
> > > > > the
> > > > > target machine?
> > > > >
> > > > >
> > >
> > >
> >
> >
> >
>
>|||Task Mgr is not reliable when it comes to AWE. What you want is to use Perf
Mon and there is a SQL Server object - Memory Manager. It has a counter
called Total Server Memory (KB) that reports what SQL Server is really
using.
Also, you can try using the /3GB switch in conjunction with the /PAE switch.
Once you get to 12GB, then go with /PAE only.
High CPU usage can result from the fact that there is no longer a memory or
disk bottleneck and the CPU does not have to wait for data to process.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"ronnie" <ronnie@.discussions.microsoft.com> wrote in message
news:C697319B-4F09-4DCD-AD28-2E4BF51EDA41@.microsoft.com...
Thanks for the quick response, Tom. I have made the changes as you suggested
and
rebooted the server. What I have noticed now in the Task Manager is that
sqlservr.exe is
only using about 120 MB of the 6 GB memory while the CPU usage has gone to
almost
100 % whilst earlier with the /3GB switch in place the memory used by
sqlservr.exe
was almost 2700 MB and the CPU usage was below 10 %.
I haven't heard any user complaints about the system being slow but I am
very puzzled
by this SQL Server behavior.
Current Server configuration:
SQL Server 2000 Enterprise Edition Version 8.00.2187
Windows Server 2003 Enterprise Edition SP2
Intel Xeon X7350 2.93 GHz
6 GB RAM
/PAE enabled in boot.ini
AWE enabled and max server memory is 5GB
(Earlier it had the /3GB switch in boot.ini and AWE disabled)
Old Server configuration:
SQL Server 2000 Enterprise Edition Version 8.00.2187
Windows Advanced Server 2000 SP4
Intel Pentium III 1400 MHz
4 GB RAM
/3 GB switch enabled in boot.ini
AWE not enabled and SQL Server using a maximum of 3 GB of RAM.
"Tom Moreau" wrote:
> Yes. Use:
> sp_configure 'awe', 1
> go
> reconfigure with override
> go
> sp_configure 'max server memory', 5120
> go
> reconfigure with override
> go
> Then, stop and start SQL Server.
>
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "ronnie" <ronnie@.discussions.microsoft.com> wrote in message
> news:A461C42F-6D8B-4121-A127-7C568F5ECF93@.microsoft.com...
> The server now has 6 GB of RAM. So do I enable AWE and set maximum server
> memory to
> 5 GB with sp_configure? I will leave the /PAE switch in the boot.ini file
> and take out the
> /3GB switch from it.
> "Tom Moreau" wrote:
> > Earlier, you said "the RAM is going to be increased to 6 GB". So does
the
> > server have that much physical RAM now? If not, then wait until you
have
> it
> > before turning on AWE.
> >
> > --
> > Tom
> >
> > ----
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > SQL Server MVP
> > Toronto, ON Canada
> > https://mvp.support.microsoft.com/profile/Tom.Moreau
> >
> >
> > "ronnie" <ronnie@.discussions.microsoft.com> wrote in message
> > news:B23DEDE0-4CE2-4119-BC6F-BB632C5FAE15@.microsoft.com...
> > Hi Tom,
> >
> > I have put in both the /PAE and /3GB switches as you suggested. Now the
> SQL
> > Server is only using 3GB of memory. I want the SQL server to use 5 GB
out
> of
> > 6 GB of memory and leave the 1 GB memory for the OS. How can I achieve
> this?
> >
> > Thanks in advance.
> >
> > "Tom Moreau" wrote:
> >
> > > That's different. In That case, I'd turn on both - once you get the
> extra
> > > memory. Above 12GB, remove the /3GB switch:
> > >
> > >
> >
>
http://groups.google.ca/group/microsoft.public.sqlserver.clustering/browse_thread/thread/5eef281ae5d7ff59/0e83b85ef5b91530?hl=en&lnk=st&q=pae+3gb+hiten#0e83b85ef5b91530
> > >
> > > --
> > > Tom
> > >
> > > ----
> > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > > SQL Server MVP
> > > Toronto, ON Canada
> > > https://mvp.support.microsoft.com/profile/Tom.Moreau
> > >
> > >
> > > "ronnie" <ronnie@.discussions.microsoft.com> wrote in message
> > > news:051D8B41-A6F2-49FA-93A4-4DE697956DEC@.microsoft.com...
> > > I just got to know that the RAM is going to be increased to 6 GB on
the
> > > target server before it goes into Production. How does it affect the
> /PAE
> > or
> > > the /3GB switch in boot.ini file and the AWE enabled / disabled on SQL
> > > Server?
> > >
> > > Thanks in advance.
> > >
> > > "ronnie" wrote:
> > >
> > > > Thanks a lot Tom for the quick response. Can you please explain the
> > reason
> > > > why you want to have that change so that I can have a better
> > understanding
> > > > of
> > > > what's going on? Also, the target server has a Windows 2003 server
in
> > > > comparison to the current server that is running on Windows 2000
> server.
> > > >
> > > > What would happen if the AWE is enabled? Thanks in advance.
> > > >
> > > > "Tom Moreau" wrote:
> > > >
> > > > > Your target BOOT.INI has the /PAE switch enabled. Remove it and
use
> > > > > /3GB.
> > > > >
> > > > > --
> > > > > Tom
> > > > >
> > > > > ----
> > > > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > > > > SQL Server MVP
> > > > > Toronto, ON Canada
> > > > > https://mvp.support.microsoft.com/profile/Tom.Moreau
> > > > >
> > > > >
> > > > > "ronnie" <ronnie@.discussions.microsoft.com> wrote in message
> > > > > news:C14D97C4-6190-4632-9A7B-D619F992B5CB@.microsoft.com...
> > > > > Hi,
> > > > >
> > > > > I am moving the default instance of a SQL Server 2000 to a ESX
> Server
> > > > > running on VMWare. Below are the specifications:
> > > > >
> > > > > Current Server:
> > > > >
> > > > > SQL Server 2000 Enterprise Edition Version 8.00.2187
> > > > > Windows Advanced Server 2000 SP4
> > > > > Intel Pentium III 1400 MHz
> > > > > 4 GB RAM
> > > > > /3 GB switch enabled in boot.ini
> > > > > AWE not enabled and SQL Server using a maximum of 3 GB of RAM.
> > > > >
> > > > >
> > > > > Target Server:
> > > > >
> > > > > SQL Server 2000 Enterprise Edition Version 8.00.2187
> > > > > Windows Server 2003 Enterprise Edition SP2
> > > > > Intel Xeon X7350 2.93 GHz
> > > > > 3.75 GB RAM
> > > > > /PAE 3 GB switch enabled in boot.ini
> > > > > AWE not enabled
> > > > >
> > > > > The target server is running on VMWare and we will be adding more
> > memory
> > > > > to
> > > > > it if it is needed in the future. What AWE setting should I be
using
> > on
> > > > > the
> > > > > target machine?
> > > > >
> > > > >
> > >
> > >
> >
> >
> >
>
>

Moving SQL Databases.

Greetings Everyone!
I currently have a Win2000 Server running SQL 2000 with cubes and databases
running properly. I want to add more but my current server is not strong
enough.
So we have purchased a new server with Win2003 Server.
I have installed SQL Server 2000 on the new server as well.
I know there are many different ways to transfer the databases and cubes
from the old server to the new.
I am curious which ones you all feel is the best route?
For example Backup/Restore VS Attach/Dettach or any other ways you are aware
of.
Thank You in advance for your assistance!
Hi Jeff,
There is a step by step guide for doing this from Microsoft. Take a look
at this article. There are other things to consider other than moving
the databases itself.
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default...b;en-us;314546
Either backup/restore or attach/detach will work fine. I may go for
backup/restore since the backup file might be smaller than the actual
file and you can keep the original server up and running until the new
server is ready
If your server settings are exactly the same as the old machine (server
installation path, drives assignment etc), it is even simpler. For more
details, look at my post
http://groups-beta.google.com/group/...&&d#6bcba5592c
502b09
Yih-Yoon Lee
My blog http://www.mssql-tools.com/blog
E-mail: yihyoon.online@.gmail.com
/* remove .online to send me e-mail */
Jeff wrote:
> Greetings Everyone!
> I currently have a Win2000 Server running SQL 2000 with cubes and databases
> running properly. I want to add more but my current server is not strong
> enough.
> So we have purchased a new server with Win2003 Server.
> I have installed SQL Server 2000 on the new server as well.
> I know there are many different ways to transfer the databases and cubes
> from the old server to the new.
> I am curious which ones you all feel is the best route?
> For example Backup/Restore VS Attach/Dettach or any other ways you are aware
> of.
> Thank You in advance for your assistance!
>
|||Jeff
Here are some more links you might find useful
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases to a
New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission Issues
When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf http://www.support.microsoft.com/?id=307775 Disaster
Recovery Articles for SQL Server
Hope this helps
John
"Yih-Yoon Lee" wrote:

> Hi Jeff,
> There is a step by step guide for doing this from Microsoft. Take a look
> at this article. There are other things to consider other than moving
> the databases itself.
> HOW TO: Move Databases Between Computers That Are Running SQL Server
> http://support.microsoft.com/default...b;en-us;314546
> Either backup/restore or attach/detach will work fine. I may go for
> backup/restore since the backup file might be smaller than the actual
> file and you can keep the original server up and running until the new
> server is ready
> If your server settings are exactly the same as the old machine (server
> installation path, drives assignment etc), it is even simpler. For more
> details, look at my post
> http://groups-beta.google.com/group/...ch&&d#6bcba559
2c502b09
> Yih-Yoon Lee
> My blog http://www.mssql-tools.com/blog
> E-mail: yihyoon.online@.gmail.com
> /* remove .online to send me e-mail */
> Jeff wrote:
>

Moving SQL Databases.

Greetings Everyone!
I currently have a Win2000 Server running SQL 2000 with cubes and databases
running properly. I want to add more but my current server is not strong
enough.
So we have purchased a new server with Win2003 Server.
I have installed SQL Server 2000 on the new server as well.
I know there are many different ways to transfer the databases and cubes
from the old server to the new.
I am curious which ones you all feel is the best route?
For example Backup/Restore VS Attach/Dettach or any other ways you are aware
of.
Thank You in advance for your assistance!Hi Jeff,
There is a step by step guide for doing this from Microsoft. Take a look
at this article. There are other things to consider other than moving
the databases itself.
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
Either backup/restore or attach/detach will work fine. I may go for
backup/restore since the backup file might be smaller than the actual
file and you can keep the original server up and running until the new
server is ready
If your server settings are exactly the same as the old machine (server
installation path, drives assignment etc), it is even simpler. For more
details, look at my post
http://groups-beta.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/a9ea3d1f09a92346/6bcba5592c502b09?q=Yih-Yoon+Lee+move+database+copy&_done=%2Fgroups%3Fq%3DYih-Yoon+Lee+move+database+copy%26&_doneTitle=Back+to+Search&&d#6bcba5592c502b09
Yih-Yoon Lee
My blog http://www.mssql-tools.com/blog
E-mail: yihyoon.online@.gmail.com
/* remove .online to send me e-mail */
Jeff wrote:
> Greetings Everyone!
> I currently have a Win2000 Server running SQL 2000 with cubes and databases
> running properly. I want to add more but my current server is not strong
> enough.
> So we have purchased a new server with Win2003 Server.
> I have installed SQL Server 2000 on the new server as well.
> I know there are many different ways to transfer the databases and cubes
> from the old server to the new.
> I am curious which ones you all feel is the best route?
> For example Backup/Restore VS Attach/Dettach or any other ways you are aware
> of.
> Thank You in advance for your assistance!
>|||Jeff
Here are some more links you might find useful
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases to a
New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission Issues
When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf http://www.support.microsoft.com/?id=307775 Disaster
Recovery Articles for SQL Server
Hope this helps
John
"Yih-Yoon Lee" wrote:
> Hi Jeff,
> There is a step by step guide for doing this from Microsoft. Take a look
> at this article. There are other things to consider other than moving
> the databases itself.
> HOW TO: Move Databases Between Computers That Are Running SQL Server
> http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
> Either backup/restore or attach/detach will work fine. I may go for
> backup/restore since the backup file might be smaller than the actual
> file and you can keep the original server up and running until the new
> server is ready
> If your server settings are exactly the same as the old machine (server
> installation path, drives assignment etc), it is even simpler. For more
> details, look at my post
> http://groups-beta.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/a9ea3d1f09a92346/6bcba5592c502b09?q=Yih-Yoon+Lee+move+database+copy&_done=%2Fgroups%3Fq%3DYih-Yoon+Lee+move+database+copy%26&_doneTitle=Back+to+Search&&d#6bcba5592c502b09
> Yih-Yoon Lee
> My blog http://www.mssql-tools.com/blog
> E-mail: yihyoon.online@.gmail.com
> /* remove .online to send me e-mail */
> Jeff wrote:
> > Greetings Everyone!
> >
> > I currently have a Win2000 Server running SQL 2000 with cubes and databases
> > running properly. I want to add more but my current server is not strong
> > enough.
> > So we have purchased a new server with Win2003 Server.
> > I have installed SQL Server 2000 on the new server as well.
> >
> > I know there are many different ways to transfer the databases and cubes
> > from the old server to the new.
> >
> > I am curious which ones you all feel is the best route?
> > For example Backup/Restore VS Attach/Dettach or any other ways you are aware
> > of.
> >
> > Thank You in advance for your assistance!
> >
>

Moving SQL Databases.

Greetings Everyone!
I currently have a Win2000 Server running SQL 2000 with cubes and databases
running properly. I want to add more but my current server is not strong
enough.
So we have purchased a new server with Win2003 Server.
I have installed SQL Server 2000 on the new server as well.
I know there are many different ways to transfer the databases and cubes
from the old server to the new.
I am curious which ones you all feel is the best route?
For example Backup/Restore VS Attach/Dettach or any other ways you are aware
of.
Thank You in advance for your assistance!Hi Jeff,
There is a step by step guide for doing this from Microsoft. Take a look
at this article. There are other things to consider other than moving
the databases itself.
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/defaul...kb;en-us;314546
Either backup/restore or attach/detach will work fine. I may go for
backup/restore since the backup file might be smaller than the actual
file and you can keep the original server up and running until the new
server is ready
If your server settings are exactly the same as the old machine (server
installation path, drives assignment etc), it is even simpler. For more
details, look at my post
bcba5592c" target="_blank">http://groups-beta.google.com/group...r />
bcba5592c
502b09
Yih-Yoon Lee
My blog http://www.mssql-tools.com/blog
E-mail: yihyoon.online@.gmail.com
/* remove .online to send me e-mail */
Jeff wrote:
> Greetings Everyone!
> I currently have a Win2000 Server running SQL 2000 with cubes and database
s
> running properly. I want to add more but my current server is not strong
> enough.
> So we have purchased a new server with Win2003 Server.
> I have installed SQL Server 2000 on the new server as well.
> I know there are many different ways to transfer the databases and cubes
> from the old server to the new.
> I am curious which ones you all feel is the best route?
> For example Backup/Restore VS Attach/Dettach or any other ways you are awa
re
> of.
> Thank You in advance for your assistance!
>|||Jeff
Here are some more links you might find useful
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases to a
New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission Issues
When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf http://www.support.microsoft.com/?id=307775 Disaster
Recovery Articles for SQL Server
Hope this helps
John
"Yih-Yoon Lee" wrote:

> Hi Jeff,
> There is a step by step guide for doing this from Microsoft. Take a look
> at this article. There are other things to consider other than moving
> the databases itself.
> HOW TO: Move Databases Between Computers That Are Running SQL Server
> http://support.microsoft.com/defaul...kb;en-us;314546
> Either backup/restore or attach/detach will work fine. I may go for
> backup/restore since the backup file might be smaller than the actual
> file and you can keep the original server up and running until the new
> server is ready
> If your server settings are exactly the same as the old machine (server
> installation path, drives assignment etc), it is even simpler. For more
> details, look at my post
> http://groups-beta.google.com/group...rch&&d#6bcba559
2c502b09
> Yih-Yoon Lee
> My blog http://www.mssql-tools.com/blog
> E-mail: yihyoon.online@.gmail.com
> /* remove .online to send me e-mail */
> Jeff wrote:
>

Moving SQL 6.5 from NT 4.0 to W2K3. Please help

Hello,
As part of Active Directory migration (from NT 4.0 to Server 2003
Enterprise), we will be replacing our current SQL server hardware with a
newer server which will be running windows 2003. Can anyone point me to any
document on how to go about doing this please. I am very new to SQL
migration, what are the things that I should be watching? The customer does
not want to upgrade to SQL2000 (prefers to stay with 6.5). Any issues with
doing that?
ThanksHi
SQL 6.5 is not supported on Windows 2003, and neither is SQL Server 7.0
SQL 6.5 is no longer supported since 31-Jan-2002 and SQL 7.0 dies
31-Dec-2005.
SQL 2000 is his only option.
http://support.microsoft.com/gp/lifesrvr
--
--
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/
"warsai" <warsai@.discussions.microsoft.com> wrote in message
news:842BB3B4-47AF-499C-B0BC-A91683255F7E@.microsoft.com...
> Hello,
> As part of Active Directory migration (from NT 4.0 to Server 2003
> Enterprise), we will be replacing our current SQL server hardware with a
> newer server which will be running windows 2003. Can anyone point me to
any
> document on how to go about doing this please. I am very new to SQL
> migration, what are the things that I should be watching? The customer
does
> not want to upgrade to SQL2000 (prefers to stay with 6.5). Any issues with
> doing that?
> Thanks
>