Restore Database

If I would like to create a training database (abctest) by restoring the
production database (abcprod), I would like to know
1) Is it necessary for me to create abctest first OR just restore the backup
of abcprod and the training database will be created automatically ?
2) There are around 10 users in the production database, when the training
database is created, will the Server Login name get confused ? OR They are
still able to connect to production database only (It is what we are after)
?
3) If we would like the same user access both production and testing
database with the same Server Login, what steps should I do ?
Besides, I would like to know how to find out the transaction log backup
model (differential, full ... ) ?Mark
Preform RESOTRE command directly , I mean you don't need to create a
database in first place
If you do RESTOREon the same server , there is no need to move logins and
users
"Mark" <Mark@.discussions.microsoft.com> wrote in message
news:Otj1Sui9FHA.3208@.TK2MSFTNGP11.phx.gbl...
> If I would like to create a training database (abctest) by restoring the
> production database (abcprod), I would like to know
> 1) Is it necessary for me to create abctest first OR just restore the
> backup of abcprod and the training database will be created automatically
> ?
> 2) There are around 10 users in the production database, when the training
> database is created, will the Server Login name get confused ? OR They
> are still able to connect to production database only (It is what we are
> after) ?
> 3) If we would like the same user access both production and testing
> database with the same Server Login, what steps should I do ?
> Besides, I would like to know how to find out the transaction log backup
> model (differential, full ... ) ?
>
>|||Dear Uri,
Thank you for your advice.
I would like to seek your advice that is it necessary for me to go to Login
name and grant the access right to the testing database for each user ?
Besides, someone suggests that Attach Database can do the same thing, is it
correct ? Is there any difference between RESTORE and ATTACH ?
Thank you for your help.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OVAzP9k9FHA.1188@.TK2MSFTNGP12.phx.gbl...
> Mark
> Preform RESOTRE command directly , I mean you don't need to create a
> database in first place
> If you do RESTOREon the same server , there is no need to move logins and
> users
>
>
> "Mark" <Mark@.discussions.microsoft.com> wrote in message
> news:Otj1Sui9FHA.3208@.TK2MSFTNGP11.phx.gbl...
>> If I would like to create a training database (abctest) by restoring the
>> production database (abcprod), I would like to know
>> 1) Is it necessary for me to create abctest first OR just restore the
>> backup of abcprod and the training database will be created automatically
>> ?
>> 2) There are around 10 users in the production database, when the
>> training database is created, will the Server Login name get confused ?
>> OR They are still able to connect to production database only (It is what
>> we are after) ?
>> 3) If we would like the same user access both production and testing
>> database with the same Server Login, what steps should I do ?
>> Besides, I would like to know how to find out the transaction log backup
>> model (differential, full ... ) ?
>>
>|||Mark
> Besides, someone suggests that Attach Database can do the same thing, is
> it correct ? Is there any difference between RESTORE
Yes, obviusly , you can use ATTACH database as it is describsed in the BOL,
but I prefer to use BACKUP/RESTORE command
"Mark" <Mark@.discussions.microsoft.com> wrote in message
news:egcLNml9FHA.3804@.TK2MSFTNGP14.phx.gbl...
> Dear Uri,
> Thank you for your advice.
> I would like to seek your advice that is it necessary for me to go to
> Login name and grant the access right to the testing database for each
> user ?
> Besides, someone suggests that Attach Database can do the same thing, is
> it correct ? Is there any difference between RESTORE and ATTACH ?
> Thank you for your help.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OVAzP9k9FHA.1188@.TK2MSFTNGP12.phx.gbl...
>> Mark
>> Preform RESOTRE command directly , I mean you don't need to create a
>> database in first place
>> If you do RESTOREon the same server , there is no need to move logins and
>> users
>>
>>
>> "Mark" <Mark@.discussions.microsoft.com> wrote in message
>> news:Otj1Sui9FHA.3208@.TK2MSFTNGP11.phx.gbl...
>> If I would like to create a training database (abctest) by restoring the
>> production database (abcprod), I would like to know
>> 1) Is it necessary for me to create abctest first OR just restore the
>> backup of abcprod and the training database will be created
>> automatically ?
>> 2) There are around 10 users in the production database, when the
>> training database is created, will the Server Login name get confused ?
>> OR They are still able to connect to production database only (It is
>> what we are after) ?
>> 3) If we would like the same user access both production and testing
>> database with the same Server Login, what steps should I do ?
>> Besides, I would like to know how to find out the transaction log backup
>> model (differential, full ... ) ?
>>
>>
>