I need to backup data on Computer A and restore on Computer B.
How do I do that?
Both are SQL Server 2005.
--
Arne Garvander
(I program VB.Net for fun and C# to get paid.)

"Arne Garvander" <ArneGarvander@discussions.microsoft.com> wrote in message
news:FB00824B-22CA-4BC6-83BA-809388A54699@microsoft.com...
>I need to backup data on Computer A and restore on Computer B.
> How do I do that?
> Both are SQL Server 2005.
> --
> Arne Garvander
> (I program VB.Net for fun and C# to get paid.)

Hi

If you want to do this in T-SQL lookup the BACKUP command in Books Online.
If you want to use Management studio right click the database and you will
see backup/restore commands on the tasks menu. You can either backup locally
and copy the backup file or backup and/or restore using UNC reference.

John

I tried backup and restore but I must have done something wrong. It did not
work.
Then I tried detach, copy, and attach. That route worked fine.
--
Arne Garvander
(I program VB.Net for fun and C# to get paid.)


"John Bell" wrote:

>
> "Arne Garvander" <ArneGarvander@discussions.microsoft.com> wrote in message
> news:FB00824B-22CA-4BC6-83BA-809388A54699@microsoft.com...
> >I need to backup data on Computer A and restore on Computer B.
> > How do I do that?
> > Both are SQL Server 2005.
> > --
> > Arne Garvander
> > (I program VB.Net for fun and C# to get paid.)
>
> Hi
>
> If you want to do this in T-SQL lookup the BACKUP command in Books Online.
> If you want to use Management studio right click the database and you will
> see backup/restore commands on the tasks menu. You can either backup locally
> and copy the backup file or backup and/or restore using UNC reference.
>
> John
>
>

If you are looking for an answer to the problem you experienced with
back\restore then you should tell us the error message you got.

However, I guess it failed because you ignored to consider the databases
files' path. The paths might be different on your Com A and Com B. I mean,
the files paths on Com A may not be existed on Com B and if you don't take
this into account then your restore simply fails.

--
Ekrem Önsoy



"Arne Garvander" <ArneGarvander@discussions.microsoft.com> wrote in message
news:68E3A1F8-6723-4DF2-A436-D2AB28D97E8E@microsoft.com...
>I tried backup and restore but I must have done something wrong. It did not
> work.
> Then I tried detach, copy, and attach. That route worked fine.
> --
> Arne Garvander
> (I program VB.Net for fun and C# to get paid.)
>
>
> "John Bell" wrote:
>
>>
>> "Arne Garvander" <ArneGarvander@discussions.microsoft.com> wrote in
>> message
>> news:FB00824B-22CA-4BC6-83BA-809388A54699@microsoft.com...
>> >I need to backup data on Computer A and restore on Computer B.
>> > How do I do that?
>> > Both are SQL Server 2005.
>> > --
>> > Arne Garvander
>> > (I program VB.Net for fun and C# to get paid.)
>>
>> Hi
>>
>> If you want to do this in T-SQL lookup the BACKUP command in Books
>> Online.
>> If you want to use Management studio right click the database and you
>> will
>> see backup/restore commands on the tasks menu. You can either backup
>> locally
>> and copy the backup file or backup and/or restore using UNC reference.
>>
>> John
>>
>>