I have an instance that houses both the production and the test database of the same app
production db name = frliv
test db name = test
the sql server is 2008.
normally i will grab the backup files off of the network share and restore the test database from the "restore from file" option for this process
this time i would like to click on the frliv database and use the restore database function and point it to the proper restore database and the proper restore "test" files
i haven't done this before so i want to make sure that nothing will happen to the frliv (prod) database if i go this route.
Can someone confirm that this process is ok to use.
Attached is a screenshot with details
thanks a bunch