| Author |
Work with 2 same database with 2 differents name
|
|
| socanphil 2006-01-25, 3:25 am |
| I have a database: toto.db
I have a backup : toto.Bak
I want to rename toto.db to titi.db
Next i restore toto.Bak to toto.db
Now I have 2 databases toto.db and titi.db
How can i do that ?
The 2 databases toto.db , titi.db be on on same server on same time
Thank's
| |
|
| Rename the Database toto to titi.
Using sp_renamedb
Restore the backup with move option as toto.
Look at books online for restore database command , with move option.
Regards
Amish Shah
| |
| Bobby Henningsen 2006-01-25, 3:25 am |
| Well,
you could simply do this :
Use your Enterprise Mngr to restore your backup of toto. Before hitting the
OK button go to the name field and change the name to "titi" and there you
have it.
Regards :)
Bobby Henningsen
"amish" <shahamishm@gmail.com> skrev i en meddelelse
news:1138172641.454122.128560@g14g2000cwa.googlegroups.com...
> Rename the Database toto to titi.
> Using sp_renamedb
> Restore the backup with move option as toto.
> Look at books online for restore database command , with move option.
>
> Regards
> Amish Shah
>
|
|
|
|