Need to back up a database and then restore it on another server

I need to back up a production database on one server and then copy it to a test server wherel it will be restored. The problem is that I don't know where to move the file to on the production server before I restore it. Is there a special folder I need to copy the file to? I see a folder named ProgramFiles\Microsoft SQL Server but beyond that I have no idea where to copy the file so that it can be restored?

Can someone help me out please?

After backing up your database to file on your production server, you should move the .bak file to your test server for restore. It does not matter where you put it on the test server as you will be able to browse for it when you actually perform the restore.

Need restore help...

Hi,
I am trying to find out where SQL Server 2000 writes
when and which last position of a transaction log was
restored. I am restoring full database backup,
differential backup and multiple transaction logs.
Full backup = 1 x week
Differential backup = 6 x week
Transaction log backup = hourly
I am restoring this to another server via SQL Server
Agent jobs. When I get the error of:
The log in this backup set begins at LSN
39300000000091600001, which is too late to apply to
the database. An earlier log backup that includes LSN
38932000000015600001 can be restored. [SQLSTATE 42000]
(Error 4305) RESTORE LOG is terminating abnormally.
[SQLSTATE 42000] (Error 3013). The step failed.
There must be a comparison going on somewhere... where
there is some value that gives the last position or
number of the last time a transaction log was restored.
I am hoping that someone from microsoft comes to my
rescue or anyone else who knows where i can find this
information. This is very valuable information that will
help in releaving this error from happening.
Please advise...
Cheers!
Brettif you do
RESTORE HEADERONLY FROM ...
you will see the first LSN and last LSN.
"Brett" <anonymous@.discussions.microsoft.com> wrote in message
news:084d01c3d6e3$30e1a3c0$a001280a@.phx.gbl...
> Hi,
> I am trying to find out where SQL Server 2000 writes
> when and which last position of a transaction log was
> restored. I am restoring full database backup,
> differential backup and multiple transaction logs.
> Full backup = 1 x week
> Differential backup = 6 x week
> Transaction log backup = hourly
> I am restoring this to another server via SQL Server
> Agent jobs. When I get the error of:
> The log in this backup set begins at LSN
> 39300000000091600001, which is too late to apply to
> the database. An earlier log backup that includes LSN
> 38932000000015600001 can be restored. [SQLSTATE 42000]
> (Error 4305) RESTORE LOG is terminating abnormally.
> [SQLSTATE 42000] (Error 3013). The step failed.
> There must be a comparison going on somewhere... where
> there is some value that gives the last position or
> number of the last time a transaction log was restored.
> I am hoping that someone from microsoft comes to my
> rescue or anyone else who knows where i can find this
> information. This is very valuable information that will
> help in releaving this error from happening.
> Please advise...
> Cheers!
> Brett
>