flavo
asked on
Copy Database - SP's
<Access Sage, SQL n00b>
I've read all the posts I could find relating to this Q, but still a little unsure.
I can tell it's not the nicest thing that I could be doing, but I'm not too worried, it's not really a "Mission Critical Application"
What a need to do is make a copy of a "base" database so that a user can use it to do sensitivity tests, using SP's that I can call from the client side.
I know that it can be done, but what sort of things do I need to worry about. User's shouldn't be a problem, as I doubt there will ever be more than 1 (2 if I'm "lucky") user(s). If worst comes to worst, I could boot 'em out.
Things I'm worried about
- Users logins (just the 1)
- Server "crapping" its self
- Database doing as above
- Anything else that comes to mind
P.S. I can do it, just need to know what can go wrong
Dave.
I've read all the posts I could find relating to this Q, but still a little unsure.
I can tell it's not the nicest thing that I could be doing, but I'm not too worried, it's not really a "Mission Critical Application"
What a need to do is make a copy of a "base" database so that a user can use it to do sensitivity tests, using SP's that I can call from the client side.
I know that it can be done, but what sort of things do I need to worry about. User's shouldn't be a problem, as I doubt there will ever be more than 1 (2 if I'm "lucky") user(s). If worst comes to worst, I could boot 'em out.
Things I'm worried about
- Users logins (just the 1)
- Server "crapping" its self
- Database doing as above
- Anything else that comes to mind
P.S. I can do it, just need to know what can go wrong
Dave.
ASKER
I got those (FE conneciton) bits under control. I'm worried about the SQL Server bombing out.
I will make a back up of the "base db"
Then restore it to the "play db"
Do i need to kick users out of the "base" db?
Is it going to die if i don't?
Where should I keep user logins to misimise work?
I will make a back up of the "base db"
Then restore it to the "play db"
Do i need to kick users out of the "base" db?
Is it going to die if i don't?
Where should I keep user logins to misimise work?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sounds like its win win.
Thanks
Dave
Thanks
Dave
If you provide the user(s) a copy of the database, you simply have to ensure that the application points to the correct database, and let them play. If they find a way to break the application or a bug, they have to report it, you fix the problem in the application, and recreate the test database again for new tests....