SS7 - Restoring from backup-How to specify destination?

[JohnBates]

Hello again -

Today I discovered that 1 of my SQL Server 7 tables has been cleared - 0 rows.

We want to determine which day this occurred on so we can do more investigating as to who / how....

I want to restore to my Test server.
I have several daily backups. When I clicked on 'Restore'
I got a window that had the 'From' path etc

After clicking OK, it immediately presented a progress bar saying "SQL Server is currently in the process of restoring the backup set"

Not what I expected so I quickly Canceled out of it.

Maybe it would have later prompted me for a destination database..... but I'm afraid I may accidentally restore to my production db and didn't want to tisk that.

My question is just this : When/how will I be able to specify the server I want to restore TO ?

I am doing this within Enterprise Manager. SS 7

Thanks, John

 

[redlam]

Hi John.
If you are using the Restore Database Wizard, you can specify a different database destination by changing the database name in the 'Restore database as:' box.

 

[tlbroadbent]

On the first screen - Restore Database - there is a field, Restore as Database. Type the name of the new database in that box. Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[JohnBates]

Thanks guys for responding.... here is an update on the situation.

Yes I am using the Restore Wizard.

Now when I attempt the restore it gives message
"Database in use. The system administrator must have exclusive use of the database to run the restore operation. Restore terminated abnormally.
SQL-DMO (ODBC SQLState: 42000) "

My system admin assures me that my login has the necessary
authority/permissions to do a restore.

Of the processes that are running on the Destination server,
all of them have Status of Sleeping or Background... these
cannot be killed( the Kill Process option is grayed-out). My login job is the only process that has 'Runnable'.

Is there some process that needs to be stopped before I attempt the restore... or is it likely a permissions problem ?


I have searched Books Online as well as Tek-Tips FAQs.

Your help is appreciated.

Thanks, John

 

[redlam]

It doesn't sound like a permissions issue and although it may appear that you are the only logged into the database, any user connection, whether its actively performing a task or not will cause this error upon restore. Be sure that you yourself do not have an active connection via Query Analyzer or any other application while attempting the restore in Enterprise Manager. You might try putting the database in Single User Mode but I suspect you'll run into the same issue if you are unable to disconnect all users. Another option is to restore this database into a completely new database on the fly. In the 'Restore database as:' box, enter a completely new database name. I believe you will be prompted for the database specs. SQL will automatically create a new database for you as part of the restore and it would be nearly impossible for user connections to interfere with this task. If nothing else works, you may consider stopping and restarting the SQL Service? This is a sure-fire (yet rude) way of assuring that no user is connected... keep in mind that this will affect users in the live system also.

 

[schakkoli451]

Need a small clarification from you regarding
restoring the database in Sql server 7.0.

I had created a full database backup for ex:sales
database and had written a backup job to run every
day.After a week I was asked to restore the first days
back up.

The backup job is updated daily only on this single

d:\MSSQL7\BACKUP\SALES.BAK file.


What actually I need is since I am running the job
every day,whatever changes I make to the database
are updated accordingly in this backup every day.I had
deleted few tables and lot of data in other tables
and all this have been updated in the backup on a
daily basis.


Since I am running the job every day to a single backup file.Is there a way I can restore the first day's data with all the tables and data in it

Looking forward to your support and assistance.


Regards
Shiva
mail to :<schakkoli@yahoo.com>

 

[tlbroadbent]

Shiva,

Please post your question in a new thread. You'll likely get a faster answer if you do so. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.