September 10, 2010 at 2:52 pm
Hello All...
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)
Then
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
2.Restoring it
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)
Thanks
September 11, 2010 at 3:00 pm
nari.koud (9/10/2010)
Hello All...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)
Then
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
2.Restoring it
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)
Thanks
You can write a t-sql script and/or create a sql job to also automate this. I would recommend you read the restore help file at http://msdn.microsoft.com/en-us/library/ms186858.aspx. Mainly the section under MOVE as you want to restore it to the same server, possibly same location.
It details all the info you will need. If you need additional assistance once you get your script going, please post that.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply