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


MS Sql Server LazyDBA home page