JWColby
jwcolby at colbyconsulting.com
Wed Aug 30 10:21:37 CDT 2006
Martin, In fact, ATM I am good to go. I may indeed run into services that SQL Server cannot perform due to the fact that it is running on a workstation OS but I just feel that I am not up to the task of becoming a Server Admin kinda guy just to get this stuff happening. Last week I actually tried installing SBS 2003 but promptly got bogged down in stuff I do not understand and don't have (or at least have never had) any need to understand. I do not want to be a Notwork guy, that is a discipline all its own and requires a lot of specialized knowledge to be good at. I am a one man show here, I have two small kids and a wife (a life in other words) and only have time to be good at a couple of things. I would love to get good at SQL Server but have just never had the opportunity. When you are a consultant you do what your clients are willing to pay you for, and to this point I have specialized in and earned a good living at Access. Yea yea, you have to study the new areas you want to learn, but you still have to have an opportunity to actually WORK in it to ever get really good at it. Otherwise everything you learn will soon be forgotten. With luck this client and this SQL Server database will provide me the means (opportunity) to become good at SQL Server. With more luck, the list members will be patient, kind and generous and I will be able to leverage this opportunity and add some valuable new skills. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Martin Reid Sent: Wednesday, August 30, 2006 4:02 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Transferring a database to another SQL Server John You may want to consider Virtural Server OS for this. Its worth looking at.Set up Windows Virtual Server 2005 which is free and work from there. I have emailed you a contact of list who deals with all my server side stuff in the University. He may be slow to respond but he knows this stuff inside out and should be able to advise or at least give you access to someone who is an expert (no disrespect to all here) on the network and OS side of things. Martin Martin WP Reid Training and Assessment Unit Riddle Hall Belfast tel: 02890 974477 ________________________________ From: dba-sqlserver-bounces at databaseadvisors.com on behalf of Jim Lawrence Sent: Wed 30/08/2006 03:41 To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Transferring a database to another SQL Server Hi John: You have an interesting catch 22 situation. MS SQL server will not fully optimize on just a work station and needs a server based environment to be able to deliver all of its services. There are some issues with WFWG and SQL server... as you are well aware. So now that you have simple networking off you will have to add a user(s) to one station and another one to the other; see your computer management on each box to do this: c:\windows\system32\compmgmt.msc. Then go to the root of each station and each drive and share it. It default names will be c$ (c drive) d$ (d drive) etc. Make sure that every new user you create on one computer is part of the administration group (god-like). If one station called 'station1' has a god-like user named 'user1' with password 'password1' which have been added to the station1's c$ and d$ share (high-light drive root, right-mouse click, select properties, tab security, add button, select new god-like user, tick all rights, apply and OK.) All another station has to do to have complete access is to 'log in to' station1 using user1, password1. Note c$ and d$ are hidden shares so you will have to key them in directly I hope the above makes sense as I am typing fast as I can as I am 10 minutes late already. Will ask any questions later. Jim PS This from a security stand-point is an absolute no-no but do we care, full connection is the name of the game.