Francisco H Tapia
my.lists at verizon.net
Thu Apr 24 16:05:16 CDT 2003
Elizabeth,
do go ahead and post the sql-dmo code, as for you current situation, The
backups always occur to local drives of where SqlServer or in this instance,
MSDE is installed. thus since you are connecting to a user's pc and you
want to backup their db, then the backup file will then be on their machine.
If you need to be able to browse to the user's pc you will need to get IS's
rights where they could assign your login semi-admin rights where you could
browse to their machine. If that is not permitted then perhaps opening up a
folder share, they can easily do this in the login script.
-Francisco
http://rcm.netfirms.com
On Thursday, April 24, 2003 1:44 PM [GMT-8],
Elizabeth <ecarey at myway.com> wrote:
: Hi,
:
: Thanks for the reply! I have spent the afternoon researching this
: and found some things that are interesting...
:
: I tried out your code:
:
: Dim con As New ADODB.Connection
: con.ConnectionString = "Provider=MSDataShape.1;Persist Security
: Info=False;Data Source=USERS_PC;User ID=sa;Initial
: Catalog=Incidents;Data Provider=SQLOLEDB.1"
: con.Open
: con.Execute "BACKUP DATABASE Incidents TO DISK=N'c:\Incidents.bak'
: WITH INIT, NOUNLOAD, " & _ "Name='Incidents', NOSKIP, NOFORMAT"
:
: And this code also seems to run, but still didn't put the file on my
: hard drive.. what it did do is put it on my USER'S hard drive. I
: just went to her desk and found every file that I had created was on
: HER computer, not mine. Hmmm. Her disk is not shared, so I have no
: way of browsing to it to retrieve the files. The code above (and my
: SQL-DMO code) throws an error if you try to send to a network drive.
:
: If anyone wants my SQL-DMO code for doing the backup from a (local)
: database I'll be happy to post it.
:
: Thanks!
: Elizabeth
:
:
: --- On Thu 04/24, Francisco H Tapia < my.lists at verizon.net >
: wrote:From: Francisco H Tapia [mailto: my.lists at verizon.net]To: dba-
: BACKUP [YOURDB] TO DISK = N'C:YourPathYourFilename.bak' WITH INIT ,
: NOUNLOAD , NAME = N'YOUR DB BACKUPName', NOSKIP , NOFORMAT
:
:
:
: _______________________________________________
: No banners. No pop-ups. No kidding.
: Introducing My Way - http://www.myway.com
: _______________________________________________
: dba-SQLServer mailing list
: dba-SQLServer at databaseadvisors.com
: http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
: http://www.databaseadvisors.com