February 24, 2005 at 4:07 pm
We are using a SQL Server for accounting purposes called FURSQL and we have a database called FUR_ACCT. To develop a web based solution we want a copy of FUR_ACCT on a different server FURTEMP with the same name. We want all the objects from FUR_ACCT to be copied to FURTEMP.
Thank you
February 24, 2005 at 4:47 pm
Backup FUR_ACCT from FURSQL and restore it to FURTEMP.
Check BOL(Book onLine) for detail.
February 25, 2005 at 2:03 am
Hi, I had problems restoring an archive database from a SQL Server 7.0 server to a SQL Server 2000 server. Although you could specify the logical filenames and the restore as database names in enterprise manager, it wouldn't let me restore the data, even if I used the Force Overwrite of Existing database option.
However, I found that the T-SQL command with the MOVE option as shown in books on-line did work, and restored the database successfully. SQLServer even migrated the database to SQLServer 2000 automatically.
RESTORE DATABASE MyNwind2_Test
FROM MyNwind_2
WITH RECOVERY,
MOVE 'MyNwind2_data' TO 'D:\MyData\MyNwind2_Test_data.mdf',
MOVE 'MyNwind2_log' TO 'D:\MyData\MyNwind2_Test_log.ldf'
David
If it ain't broke, don't fix it...
February 25, 2005 at 2:04 am
This will be made easier if the FURTEMP server has the same disk config as FURSQL, then you don't even need to change the physical file location when you restore.
February 25, 2005 at 8:41 am
David,
There is no issue with restoring a SQL 7 BAK to a SQL 2000 Server. Its relatively painless. Just need to make sure you update your stats after restoring.
Also regarding using the move option, you can do that in EM as well. In the options tab - you have the option of changing the paths for the files.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply