| Author |
Topic |
|
eurpeanbob
Starting Member
6 Posts |
 Posted - 2003-06-17 : 18:05:31
|
| morning/afternoon/eveningi am currently "working with" a DBA - whom i think, i can't be sure as i don't know ms sql [or any sql for that matter], doesn't have a clue...here's my situation [please forgive any obvious sql related config mistypes - i really am unsure of sql]there's a server on the network, machine name is DATABASE, ms sql2k instance name - 'database' - this houses various databases, ?sprocs?, structures etc etcwe have other sql machines on the network - development, olap cube, testing - these pull data from the sql instance 'database' on DATABASE - we also have an in house app which adds data to 'database'unfortunately the server is dyingconfused yet?i've been lucky enough to get hold of a far better server to replace itwhat ways can complete data/structure transfer to the new machine be achieved?the new machine can be called the same as the old one if needed - but i need to be sure of the proceedure before i let my DBA go anywhere near the server - or for him to instruct me on what he requires to happen with the machine - and consequently my network...the machine is currently running enterprise edition - is it possible to have standard running on the new machine??any help is appreciated - any related links to websites/articles etc...i'll be around until about 02:00 UK time please email me on craig [at] cmwmedia [dot] co [dot] uk - or reply to the postmany, many thanksCraig |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-17 : 18:12:28
|
| First of all, change the machine name to something that makes sense (typically SQL is part of the name). Also, the instance name shouldn't be the same as the machine name. Why not just go with the default instance instead? Is your DBA using the default instance for something else?To move the databases,[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071[/url]We use Enterprise Edition when we need to use log shipping and/or when we are installing it on Windows Data Center. All other servers, here at least, are Standard Edition.Tara |
 |
|
|
eurpeanbob
Starting Member
6 Posts |
Posted - 2003-06-17 : 18:28:48
|
| personally i want the new machine called EPSILON - which is from the name schema i've got in place for servers on the network - he says keeping the same name and same instance name will make things easier for him?? i don't know - hence asking for help :)as for the default instance - i think that's it - 'database' - he blames the guy who set it all up - but personally i'm not sure - i've read a few M$ articles and it doesn't seem to much bother for[a] server machine name to be changed[b] instance name to be changedi think this is confirming my opinion that the guy is just a lazy person [i'm being very polite here :) ]going from enterprise to standard shouldn't be a major problem either then? i've just had a look at a few docs and also read a couple of pages the SQL books i picked up from work...and i can be pretty sure in saying we don't use anything like log shipping, HTTP access, or ROLAPthanks for the reply :) very much appreciated - anyone else like to give their 2 cents? |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-06-17 : 18:34:58
|
| Depending on what that database is used for, if you change the Database Name / Instance Name, any connection strings used to connect to that server will have to be changed. Depending on where those are and how hard they are to change, you may or may not want to change the database and instance names. I suggest that you change the names to something that makes more sense for you. It sounds like that guy is either lazy, or doesn't know everything that will be affected by this change. Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-17 : 18:37:46
|
| SQL Server will need to be installed on this new server, so at that time, the DBA can pick the default instance or a named instance. The DBA does not have to pick database as the instance name. At installation time, if you want Standard Edition, then have the DBA use the CD for Std. Edt. instead of Ent. Edt. It really is that simple. Not sure why he/she is making it so difficult.I'm not sure how keeping the server name the same will help out the DBA. A server name shouldn't matter to the DBA. It certainly doesn't matter to me, just as long as it follows some standard if there is one.Tara |
|
|
|
eurpeanbob
Starting Member
6 Posts |
Posted - 2003-06-17 : 18:44:59
|
| michael: would there actually be connection strings in the sql database or is this something that's just in asp code? [i know nothing about both and am just asking from what i've heard bounced around the office]tara: thanks for that - he'll be handed the std disk tomorrow :) as for the name - EPSILON it is :)a quick question with regard to accounts too - he's currently using a domain user account as the 'sa' account - is this common practice? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-17 : 18:46:38
|
| I agree with MichaelP in that connection strings will have to be changed, but that's something that has to happen when you deploy the application to various environments. Is this DBA responsible for making connection string changes for the applications? If he/she is that's unusual unless it's a small company.Tara |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-17 : 18:50:12
|
| The sa account is no longer standard practice to use for system administration. Typically a windows account (typically it's a domain account but it can be a local account too ) is used that has system administrator permissions.Tara |
|
|
|
eurpeanbob
Starting Member
6 Posts |
Posted - 2003-06-17 : 18:53:32
|
| tara: where are connection strings? are they in the sql structure or part of the front end - like in the asp we serve on the website?--just goin out for a while to get some fresh air--Edited by - eurpeanbob on 06/17/2003 18:56:53 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-17 : 18:58:29
|
| The connection string will be on the web side of things.Tara |
|
|
|
eurpeanbob
Starting Member
6 Posts |
Posted - 2003-06-17 : 20:44:21
|
| tara: thanks for that - good news - our web dev guys take care of that - and as this machine isn't web facing - none of their code will use connection strings to this machinethanks to all those who've contributed - i hope next time i post i'll have a lot more insight into sql :)again - many thanks |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-06-17 : 21:59:09
|
| Youre not a web guy, dba guy, nor a network guy....what do you do? Server Ops?ANYTHING still needs some form of a connection to the database...What's your backgound/profession are you in if you don't mind me asking...(Oh, and as far as you feeling you're dba might be b-llsh-tting you...you could be 100% correct...man what people do when they don't know...)PS Any dba that names a database "DATABASE"...well you get the idea...for example, I have many databases...all in separate instances or different boxes, but they are named to the function they are meant to support..tax reconcillation is TaxReconDb....Content Management...well it's vingette, so thats the name...ect...Good Luck, and come back oftenBrett8-)Edited by - x002548 on 06/17/2003 22:02:11 |
|
|
|
eurpeanbob
Starting Member
6 Posts |
Posted - 2003-06-18 : 03:54:54
|
| just a quick update - i'm standin' in my server room watching this dba vnc onto the machine - trying to get the sql services to 'start'here's what "we've" done - i'm going along with his requests just to show face - i'll confront him with the info i've gathered later[1] taken DATABASE offline[2] renamed EPSILON to DATABASE[3] given DATABASE [the new one] the same IP as the old one[4] added DATABASE [yes, the new one] to the domain[5] applied NT SP6a - just for good measure[6] i've handed over to DBA to get the sql side sortednow - i know this isn't going to work - i knew this yesterday, your opinions confirmed this last night - and by what i'm watching now - i could record this session and it could go down in history as one of the funniest things evera little about me...i'm the IT / Comms / Network / Systems Administrator for a small office in the UK - I get to deal with everything from 'My mouse doesn't work - fix it' to 'We need a new Exchange server built' - and as you can probably guess - a whole host of cr*p in between. I also get to deal with morons who think they know things about systems - and when they don't are too afraid to ask - but honestly i don't think he actually knows what a forum is - at least i've never seen him use any - as an admin myself i'm never off them - who knows eh - i'm very bitter right now - i've been waiting four months for this migration to complete - i'm due to go on holiday in less than two weeks and i have a feeling it still won't be done by thento be fair he inherited the DATABASE system - but it seems it's not too much of a problem to get all that changed to something that is meaningfulhope you have a better day than i know i'm going to have :)take careCraig |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-18 : 13:56:05
|
| Let us know if need any more help. If SQL Server was already installed on EPSILON before it was renamed to DATABASE, the DBA will need to run two stored procedures to get SQL Server to know about the rename. If SQL Server wasn't installed before the renaming of the server, then nothing else needs to happen.Here is the information from SQL Server Books Online:When you change the name of the computer that is running Microsoft® SQL Server™ 2000, the new name is recognized during SQL Server startup. You do not have to run Setup again to reset the computer name. You can connect to SQL Server using the new computer name after you have restarted the server. However, to correct the sysservers system table, you should manually run these procedures:sp_dropserver <old_name>gosp_addserver <new_name>goTara |
|
|
|
jpfeffer
Starting Member
3 Posts |
Posted - 2003-06-19 : 20:10:42
|
| Bob,I think you have gotten some great info! I would also suggest you have a better screening process. If you don't trust the staff you are paying, then time for new staff. Or maybe slightly less micro-management? :) Seriously a good consultant will help you feel at ease with the whole process.JohnBite Me! |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-06-19 : 20:49:22
|
You mean a "highly paid consultant"?I'm expensive (nearly said free!) next month. ==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
non-dba requires sympathetic ear...