|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
HI FORUM,
I need u r help in backup of a sql database =>> PROBLEM 1 The following backup statement works fine on my local sql server BACKUP DATABASE [Acc] TO DISK = 'c:\bk1' WITH INIT (I use I/SQL tool / Sql Query Analyzer) Is there a way i can do this with a remote server but a local backup device. e.g. [Acc] = database on some remote server c:\bk1 = DISK device (backup device) on my local computer In other words i want to backup accross the network (internet) Is this possible ? How ? =>> PROBLEM 2 I cannot run DTS packages for data import from remote sql server as there seem to be some "priviledge problme" with my account. I get the following error : Cannot copy user [MyUserName...] .... 1 taska failed during execution THANKS IN ADVANCE |
|
#2
|
|||
|
|||
|
If you're backing up accross the network why not just build a DTS package to handle it all for you?
|
![]() |
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > Sql Backup Problems |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|