restore backup (.bak) on another computer

We are running SQL Server 2000 on a single computer. We currently backup
once a week into .bak files which we keep on file. However, if this computer
were to fail we would have to reinstall software on a new machine. How can
we restore the old database files from the backups? I have installed SQL
Server on a test machine and found that you can't just restore. The new SQL
Server doesn't immediately recognize the backups from another computer.
Does anyone know how to do this?How do you try to do the restore and what is it that doesn't work?
Have you tried looking up the RESTORE command in BOL? In QA you can run :
RESTORE DATABASE YourDataBase FROM DISK ='\\YourBackupLocation\YourBackupFile.BAK' WITH
RECOVERY, MOVE 'LogicalDataFileName' TO 'YourDatabasePath',
MOVE 'LogicalLogFileName' TO 'YourLogFilePath'
You can also do it from EM - right click on Databases ->All Task-> Restore
Database.
Regards
Steen
gl330k wrote:
> We are running SQL Server 2000 on a single computer. We currently
> backup once a week into .bak files which we keep on file. However,
> if this computer were to fail we would have to reinstall software on
> a new machine. How can we restore the old database files from the
> backups? I have installed SQL Server on a test machine and found
> that you can't just restore. The new SQL Server doesn't immediately
> recognize the backups from another computer.
> Does anyone know how to do this?|||Have a look at HOW TO: Move Databases Between Computers That Are Running SQL
Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
"gl330k" wrote:
> We are running SQL Server 2000 on a single computer. We currently backup
> once a week into .bak files which we keep on file. However, if this computer
> were to fail we would have to reinstall software on a new machine. How can
> we restore the old database files from the backups? I have installed SQL
> Server on a test machine and found that you can't just restore. The new SQL
> Server doesn't immediately recognize the backups from another computer.
> Does anyone know how to do this?|||I don't know much about SQL Server seeing as we only have one machine running
it and it is the foundation for a Solomon accounting program. I tried the
article you mentioned but it really didn't help me. The problem is that I
don't know where/what the "with restore" options are.
Here's what I just tried:
I have a database backup called woh.bak. I created a woh database in new
SQL Server 2000 (on the new machine). Then I backed it up as the name above.
I copied the original backup over the new woh.bak and restored it from
there. Apparently there is data but I don't know how to verify yet if the
data is all accurate. (IOW - i still need to install Solomon.)
Does this sound like a recipe for disaster to anyone?
"Ana Mihalj" wrote:
> Have a look at HOW TO: Move Databases Between Computers That Are Running SQL
> Server
> http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
> "gl330k" wrote:
> > We are running SQL Server 2000 on a single computer. We currently backup
> > once a week into .bak files which we keep on file. However, if this computer
> > were to fail we would have to reinstall software on a new machine. How can
> > we restore the old database files from the backups? I have installed SQL
> > Server on a test machine and found that you can't just restore. The new SQL
> > Server doesn't immediately recognize the backups from another computer.
> >
> > Does anyone know how to do this?|||I'd assume that if you have some data in the database after the restore,
you'll have it all. A restore will either fail or succeed - it won't just
restore a part of the data. If you're not sure about it, I think the only
thing you can do is to look at the data from the accounting program and then
verify that it looks ok - I doubt that any of us can help you with
that...:-).
A good tip might be to read about BACKUP and RESTORE in Books On Line or the
links below. That might help you in the future.
BACKUP : http://msdn.microsoft.com/library/en-us/tsqlref/ts_ba-bz_35ww.asp
RESTORE: http://msdn.microsoft.com/library/en-us/tsqlref/ts_ra-rz_25rm.asp
Regards
Steen
gl330k wrote:
> I don't know much about SQL Server seeing as we only have one machine
> running it and it is the foundation for a Solomon accounting program.
> I tried the article you mentioned but it really didn't help me. The
> problem is that I don't know where/what the "with restore" options
> are.
> Here's what I just tried:
> I have a database backup called woh.bak. I created a woh database in
> new SQL Server 2000 (on the new machine). Then I backed it up as the
> name above. I copied the original backup over the new woh.bak and
> restored it from there. Apparently there is data but I don't know
> how to verify yet if the data is all accurate. (IOW - i still need
> to install Solomon.)
> Does this sound like a recipe for disaster to anyone?
>
>
> "Ana Mihalj" wrote:
>> Have a look at HOW TO: Move Databases Between Computers That Are
>> Running SQL Server
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
>> "gl330k" wrote:
>> We are running SQL Server 2000 on a single computer. We currently
>> backup once a week into .bak files which we keep on file. However,
>> if this computer were to fail we would have to reinstall software
>> on a new machine. How can we restore the old database files from
>> the backups? I have installed SQL Server on a test machine and
>> found that you can't just restore. The new SQL Server doesn't
>> immediately recognize the backups from another computer.
>> Does anyone know how to do this?