Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bazpaul
Starting Member
3 Posts |
 Posted - 2008-04-14 : 10:07:04
|
| Guys!!How are you all? Im new to this forum as you can probably tell. I have joined up because i need advice in a matter and this seems like the best pace on the net for SQL Server help. Let me outline first what im trying to do;Im part of a large company of roughly 5000 or so desktops and 3000 or so laptops. We currently have a project under way where we inted to build 50 or so identical laptops that will be used for testing mechanical equipment. Now the team involved have designed there own program that will connect to a main server in Head Office and transfer over the updated SQL server databases on the latop. every couple of days after doing tests, this tests - stored in a SQL DB - will be synced with the server to prevent loss of data.Now my queston, is it possible to Clone an operating system with the following apps already installed;SQL Server 2005SQL Server Nature ClientSQL Server Setup FilesSQL Server Vss WriterI made an inital clone, but when i went into the user groups, i found SQL server users with a PC name of the inital 'base build' PC. It seems these accounts cannot be copied from one machine to another.Will the SQL database still run fine, or will there be big problems when copnnecting the the Server in Head Office?Would it be better to just install the SQL Server components after a new latop has been created?Anyway any help at all would be great on this matter, cheers!! |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-04-14 : 15:28:32
|
quote:
Originally posted by bazpaul
Guys!!How are you all?..
We are all fine, Thank you!  ------------------------I think, therefore I am - Rene Descartes |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-14 : 23:03:54
|
| >> is it possible to Clone an operating system with the following apps already installedTake look at ghost. |
|
|
|
bazpaul
Starting Member
3 Posts |
Posted - 2008-04-15 : 04:19:38
|
| Yes we use Ghost to clone machines. I am not asking about the process of cloning or how to install but if it is possible to image and installation of SQL Server 2005 and copy it to another machine?i need someone with knowledge of how SQL Server installs and runs in the backround and how it identifies itself when connecting to the server. |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-04-15 : 10:53:17
|
| We used Ghost successfully to clone SQL client tools. Not sure about the other apps in question though.Terry |
|
|
|
bazpaul
Starting Member
3 Posts |
Posted - 2008-04-15 : 10:58:47
|
| cheers!!just to all who care. This cant be done, as the SQL databases have subscriptions to the server. Basically 'SQL Server' must be installed seperately on every computer! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-15 : 22:55:45
|
| You mean set replication in sql? What we did was build a machine with clean sql server installation and clone it to others. Yes, you have to change host name and rename sql. |
|
|
|
|
|
|
|
|
Cloning a PC with SQL Server 2005