Hi,
I got a Server machine that is running both HQ Server and Store Ops DB. I would like to move the Store Ops DB to one of the Registers. How would I do that? How would I move the database file itself to one of the Registers?
What I'm guessing is:
Am I right?
Thanks
Yes that is right.
DanielSie,
No, it has a .bck extension.
Copy the file anywhere to your drive, go into SO Administrator | File | Connect | Login and put any database name in | OK, then Database | Create | Give it a name | point to your backup file. It will create the database in the \Program Files\Microsoft SQL Server\MSSQL\Data folder.
Then back to File | Connect | put in your password and the name of the DB you just created | OK
File | Configuration | go through the tabs and make sure the correct info is in each.
Jeff,
Where would I find the database file w/ the .bck extension? I could only find backup files w/ .bak extension created by Enterprise's Maintenance Plan.
"Jeff" wrote:
Daniel,
The .bck file is created when you backup your database.
Matt
..bck and .bak will both work - they are just file extensions and have no real bearing on the content of the file...
The easiest thing to do if you aren't that familiar with SQL Server is to use SO Manager or SO Admin to create a database backup (SO Manager, Utilities/Backup Database : SO Admin, Database/Backup), then use SO Administrator on the target machine to Database/Create a new Db from the backup. Some backups created by Jobs and maintenence plans may contain multiple backup sets, or be partial/incremental backups. HTefile created by the RMS backup functions will always be a very simple complete backup in a single file.
In the case of a backup file, it doesn't matter where you save it - put it on the desktop if you like - SQL Server (even MSDE) will create new data and log files in the proper location (or at least the default location - proper is subjective) when you restore the database from SQL enterprise Manager OR when you CREATE the database in SO Administrator...
You can also Detach/Attach the database - see SQL Server Books Online for more information.
I just found that I never actually completed this project...and that was 2 yrs ago!!
The method described above, it doesn't seem to work.
So in the server I opened SOA, created a backup of the store ops DB. Moved the backup file to Register1. Opened SOA in Register1. Connect to a sample database in Register1. Create a new DB in Register1 using the backup file.
This is the part where is gets c> ..bck and .bak will both work - they are just file extensions and have no
Have something to add? Share your thoughts — no account required.
Ask the community — no account required