[dba-SQLServer] Backup

I always just set up a Maintenance Plan in Enterprise Manager that controls
backups and optimizations and runs everythiing required on a nightly basis.
Have never seen the need to create backups via Access.  You could easily go
through Enterprise Manager and create a Job that does the backup then just
run that code via a Command object in VBA.

A sample backup in T-SQL looks like this:
BACKUP DATABASE [MySampleDB] TO  DISK = N'E:\Microsoft SQL
Server\MSSQL\Data\MyBak' WITH  INIT ,  NOUNLOAD ,  NAME = N'MyTest backup',
NOSKIP ,  STATS = 10,  NOFORMAT 

-Chris Mackin



-----Original Message-----
From: Martin Reid [mailto:mwp.reid at qub.ac.uk]
Sent: Thursday, May 06, 2004 11:33 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Backup


no response to the request re backing up SQL Server via Access -anyone any
examples?


Martin

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com