Showing posts with label setting. Show all posts
Showing posts with label setting. Show all posts

Monday, March 26, 2012

Need support/help to setup replication

Hello,
Anybody know who I might call to pay for help setting up replication. I am
under a time constraint.
Rick Rushing
System Administrator
D & J Construction
What type of replication, and how long do you have?
Describe the scenario please :-)
I am available by the hour or by the minute...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Rick Rushing" <RickRushing@.discussions.microsoft.com> wrote in message
news:0EBE4237-238C-48DD-AA7C-E9096AC4B9C4@.microsoft.com...
> Hello,
> Anybody know who I might call to pay for help setting up replication. I am
> under a time constraint.
> --
> Rick Rushing
> System Administrator
> D & J Construction
|||Rick,
where abouts are you geographically? If in the UK or you're happy working
remotely, please drop me a line - email address at
www.replicationanswers.com.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Monday, March 19, 2012

need solution for change file path

greeting,
i would like to ask some question about MS SQL 2000 Server.
recall: during the installation, for the setup type, there's one setting for
the destination folder for (1) program files and (2)data files
i need a solution for:
during the installation, if the user pin point the path to default
<<DRIVE>>:\program files\mssql...
now i am having a new partition for the HDD, how can i switch MSSQL ordinary
data files path directory pin point to another directory?
example : from default data files path directory c:\mssql to e:\mssql?
thank youyk.ngYou can set a new database default location by selecting the server
properties, database settings tab and update the data and log directories on
the new database default location section.
Ben Nevarez, MCDBA, OCP
Database Administrator
"zouky" wrote:
> greeting,
> i would like to ask some question about MS SQL 2000 Server.
> recall: during the installation, for the setup type, there's one setting for
> the destination folder for (1) program files and (2)data files
> i need a solution for:
> during the installation, if the user pin point the path to default
> <<DRIVE>>:\program files\mssql...
> now i am having a new partition for the HDD, how can i switch MSSQL ordinary
> data files path directory pin point to another directory?
> example : from default data files path directory c:\mssql to e:\mssql?
> thank youyk.ng
>
>

need solution for change file path

greeting,
i would like to ask some question about MS SQL 2000 Server.
recall: during the installation, for the setup type, there's one setting for
the destination folder for (1) program files and (2)data files
i need a solution for:
during the installation, if the user pin point the path to default
<<DRIVE>>:\program files\mssql...
now i am having a new partition for the HDD, how can i switch MSSQL ordinary
data files path directory pin point to another directory?
example : from default data files path directory c:\mssql to e:\mssql?
thank youyk.ngYou can set a new database default location by selecting the server
properties, database settings tab and update the data and log directories on
the new database default location section.
Ben Nevarez, MCDBA, OCP
Database Administrator
"zouky" wrote:

> greeting,
> i would like to ask some question about MS SQL 2000 Server.
> recall: during the installation, for the setup type, there's one setting f
or
> the destination folder for (1) program files and (2)data files
> i need a solution for:
> during the installation, if the user pin point the path to default
> <<DRIVE>>:\program files\mssql...
> now i am having a new partition for the HDD, how can i switch MSSQL ordina
ry
> data files path directory pin point to another directory?
> example : from default data files path directory c:\mssql to e:\mssql?
> thank youyk.ng
>
>

Saturday, February 25, 2012

Need Help. Please

Hi there,
I know it is a bit odd to ask questions on my first posting. I'm new at setting up a MS SQL 2000 Server. I would really appreciate if you can help clarify a few of my questions :) .
I'm considering to buy SQL 2000 Ent. Ed and Windows Server 2003 Ent. Ed. for my two new Servers. I've tried to contact MS customer support, but they are not very helpful :( . I've searched many articles, most of them are not very helpful in helping me make the decision :( .
I would like to set up a cluster with two Windows 2003 Server Ent. Ed. One for active SQL2000 Ent. Ed. and another one for passive. Can this work?
For the Server running the passive SQL 2000. I'll be running a java networking application. I would like to know if the passive windows server 2003 fails, will the Windows Server 2003 be able to handle the failover and transfer my java application to the other server. :confused:
Thanks a lot in advance. Any help is appreciated.

Best Regards,
Keen HonTypically, Microsoft prefers the customer to engage either an OEM or a Microsoft Solutions Provider for this kind of pre-sales support, but that is no reason for them to ignore your request. How did you try to contact customer support?

-PatP|||I called the Customer Care Centre (Microsoft Careline) for my Country in Singapore. I also called some of the Resellers. Maybe I will call the OEM to try my luck.

- KH|||You do know what you're configuring will be a lot of cash...

And you should probably get another box for the app server...

You do know that clustering is NOT for load balancing...right....and don't you want another box for shared Disk?|||Of course your application will be failed over...only if you make it a cluster-aware service.