Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vinu
Starting Member
34 Posts |
 Posted - 2010-12-16 : 00:08:30
|
| hi..i want to take the DB Backup from theremote server to the local system..i'm using sql server2008 enterprise edition and the remote server is sql server2008 expresshow to do it..please help me... |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-16 : 00:39:21
|
| Just connect to it and execute a BACKUP command.Are you saying you want to restore the remote backup to the local system? |
 |
|
|
vinu
Starting Member
34 Posts |
Posted - 2010-12-16 : 01:18:36
|
| thanks for replying..i want to take backup from remote server.the following is what i did..sql command= backup database employee to disk='//123.123.1.12/backup/back.bak'"Msg 3201, Level 16, State 1, Line 1Cannot open backup device '\\123.123.1.12\backup\back.bak'. Operating system error 1326(Logon failure: unknown user name or bad password.).Msg 3013, Level 16, State 1, Line 1BACKUP DATABASE is terminating abnormally."wat to do.. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-16 : 01:24:36
|
| You need to give permissions on \\123.123.1.12\backup\ to the SQL Server service account. |
|
|
|
vinu
Starting Member
34 Posts |
Posted - 2010-12-16 : 01:31:27
|
| how to give the permission .. i dont know.. |
|
|
|
|
|
|
how to take DataBase Backup from remote server to