I did the refresh at the role level instead of the database level and it
worked.

Thanks!

Allan

-----Original Message-----
From: Hyra, Bev A [mailto:[Email Address Removed] Friday, February 21, 2003 10:31 AM
To: 'Wilson, Allan'
Subject: RE: Roles not created after Restore From Device


Maybe you are seeing a quirk with enterprise manager. I have seen this
before. I thought once that all the users were not given access to a
database after a restore.

If you were looking at the database you need to backup and do a refresh on
the db (right click and select refresh), then go back in and look at the
roles.

-----Original Message-----
From: Wilson, Allan [mailto:Allan.[Email Address Removed] Friday, February 21, 2003 8:24 AM
To: LazyDBA.com Discussion
Subject: Roles not created after Restore From Device


I'm an Oracle DBA that now must handle some SQL Server duties.

We have some old SQL Server 7.0 (with sp4) installations that I have to do
restores on to refresh test data for the development team. Periodically
I'll get a new database dump from outside the company and restore it to one
of our servers.

The process that I use is this:
1) Create a new emtpy database with the same name database to be restored
from the dump file.
2) Put database in single user mode
3) Run a Restore From Device with the force restore over existing database
option.

Sometimes when I do this restore, the roles that are in the database dump do
not get created. Can someone shed some light on this probleam and what I
can do to help ensure that these roles get created during the restore?

The database dump does indeed have the roles included because sometimes the
restore from the same dump file will produce the roles.

Thanks

Allan



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page