SQL server 2000 question -- sql server new users

sql server new users : SQL server 2000 question

petertgaffney NO[at]SPAM gmail.com
6/28/2006 8:14:19 AM

Hi.

Can I restore to database MyTempDB from database MyProductionDB's
backup and log files while MyProductionDB has active users?

Thanks.

Arnie Rowland
6/28/2006 8:58:29 AM

You don't want to do that!

TempDb is a 'scratch' pad. Intermediate staging for users occurs there. It
completely 'goes away' at times. Every time the Server is restarted, TempDb
is recreated anew

Restoring MyProductionDb to TempDb would only waste space.

What are you trying to accomplish?

--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."

*Yet Another Certification Exam

[quoted text, click to view]

petertgaffney NO[at]SPAM gmail.com
6/28/2006 9:59:01 AM

Sorry, let me clarify. I'm not trying to restore to TempDB, I'm trying
to restore to some database (hypothetically called MyTempDB) so I can
verify whether or not my backup scheme is doing what it's supposed to
without booting everyone off the database whose backup files I'm
restoring; that is I'm restoring the backup files from database A into
database B while database A has active users.

Thanks,

Peter

Arnie Rowland
6/28/2006 10:10:22 AM

The restore operation will have no effect on the 'live' production database
UNLESS you restore the live production database.

If you restore from a backup copy, and restore to a different db name (a
different server is best for this purpose) there should be little impact to
the users.

--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."

*Yet Another Certification Exam

[quoted text, click to view]

Lawrence Garvin (MVP)
7/6/2006 4:16:00 PM

[quoted text, click to view]

Not to mention possibly crash any process/procedure/application currently
reading/writing to tempDB, and possibly even crashing/corrupting any active
database on the server.

--
Lawrence Garvin, M.S., MVP-Software Distribution
Everything you need for WSUS is at
http://technet2.microsoft.com/windowsserver/en/technologies/featured/wsus/default.mspx
And, eveything else is at
http://wsusinfo.onsitechsolutions.com
....

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

home · blog · groups

Questions? Comments? Contact the dn