on 01-09-2008 8:28 AM
hi,
i am using sap ecc 6.0 sr2 on windows 2003 aand sql 2005.
i have taken my development backup in entriprise manager.its 53 gb..i have installed a standalone system with sam sid and tried to restores this backup.from entriprise manager.but it si throwing error
the eroor is
restore fai.led for server my server name.
aditional information:
system.data.sqlclient.sqlerror:restore canot process database 'DEV'(my sid) because it is in use by this session.it is recomeded that master datbase is used while performing this operation.
and i have take online backup.
can any one suggest me what to do to restore.
regaqrds
fahim sultan
Edited by: Fahim Sultan on Jan 9, 2008 9:28 AM
i have dropeed my sid and restored .its happening
my sid qas is to be restored with sid dev what should i do.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
First Detach database DEV from enterprise manager.
after that make sure the file structure of target system is same as of the source system and then try to restore database.
Regards
Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
for me it looks like as you are trying to restore the DEV database. This database is currently present at your system and it is in use (is the R/3 still running?).
To avoid the message you have to ensure that nobody is using the database you want to override. This can be easily ensured by dropping the database first () or by checking in the currenty activity folder, which process is using it and to kill it first.
Regards
Clas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
as Clas wrote, there are some connections left on your DB. You could try to do something like this:
use master
go
alter database <SID> set single_user with rollback immediate /* have a look at the termination options! */
go
(now you restore command follows:)
restore database...
...
(now set the DB back to multi user access:)
use master
go
alter database <SID> set multi_user
go
Regards,
Sven
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.