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" 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" 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" 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" 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 >> >>
