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 |
|
BadKarma
Starting Member
5 Posts |
 Posted - 2004-12-21 : 17:37:37
|
| I want to set up some training, but I dont want to bog down my server or open it up to "ooopsies". Do I have to install SQL Server on a seperate PC and transfer an old DB backup to have a training environment? Or can I just transfer the DB file and access it?They will be useing a Query Tool for access to the database.I really dont want to install the server because that will cause EULA issues.Without chaos there are no Admins. |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-12-21 : 17:45:58
|
| How about installing MSDE or SQL Server Developement Edition?That would allow you to restore your database. I think MSDE has a 2GB per database limit, but Developer does not. The MSDE install should be on your SQL 2000 CD, or is available from MS. The only place I know to get Developer is through an MSDN subscription.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2004-12-21 : 17:46:57
|
| The SQL Server and the databases are on the same box. Moving the database files to a different computer doesn't help.A couple of options to consider:1) Set up a Sample database or your existing server (or use the existing Pubs or Northwind databases). Have your trainees log in on an account that only has aceess rights to the Sample database.2) Install the Developer's edition on your training Server and then create or restore the training database. This is limited to five connections, I think, but I'm sure you can verify the limitation on the MS website.HTH=================================================================Sometimes I wonder whether the world is being run by smart people who are putting us on or by imbeciles who really mean it. -Mark Twain, author and humorist (1835-1910) |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-12-21 : 18:49:14
|
| I think one of the requirements was to avoid any "oppies" and not bog down his existing server, so installing SQL server on another machine is probably the way to go. Get some version of SQL server installed on another machine, then do a backup from production, and restore the file to your new development PC.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2004-12-21 : 19:22:38
|
| Si, claro...HTH=================================================================Sometimes I wonder whether the world is being run by smart people who are putting us on or by imbeciles who really mean it. -Mark Twain, author and humorist (1835-1910) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-12-22 : 04:22:27
|
| "ooopsies" is all to easy in QA isn't it - one window open on Production, one on Test. I suppose I should close the PRODUCTION windows when I'm working on TEST.Or is there a smarter way? Remove all user logins at midnight each day, on Production, so that they have to be specifically re-made each time an ad-hoc connection is required? Only grant myself Read access for "normal working" on Production?Anything else you guys use for Safe Hex?Kristen |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2004-12-22 : 09:58:15
|
| Anything else you guys use for Safe Hex?Buy a Condominium and use it!HTH=================================================================Sometimes I wonder whether the world is being run by smart people who are putting us on or by imbeciles who really mean it. -Mark Twain, author and humorist (1835-1910) |
|
|
|
|
|
|
|
|
DataBase Training