I have a database XYZ (Full Recovery Model,300 users in it size aroung 134800 MB,) on Server 1(dev)
I need to back it up to some location(z drive/disk)
I need to restore to same Server1(dev) with different name XYZ_ABC
All I know is to do in GUI and writing Basic Scripts ,but my lead needs Scripts .
Steps: 1.Doing an backup to disk z
but I am concerend about renaming the DB and restoring it on same server1(dev) ....
Can u guys help me on giving the Step -Step -Procedure to do ....What will be the steps and Scripts ??
and after restoring do i need to assign permissions to alla existing 300 users ?
(may be this one depends on my lead)
View Complete Post