MSDE Backup -- sql server msde

George Schneider
6/15/2006 2:26:01 PM

I would rather use something native to windows or even the command line like
in a script. I there anything such as this. I'm trying to stay away from
unknow tools no offense. My corporate data is dependent on this backup.

[quoted text, click to view]

Andrea Montanari
6/15/2006 4:44:04 PM

hi Georg,
[quoted text, click to view]

if you like, you can have a look at a free prj of mine, available at the
link following my sign., which provides a user interface similar to
Enteprise Manager...
backup task feature is available, as long as a simple way to schedule for
SQL Server Agent backup jobs as well... but you can define your own jobs as
desired...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
--------- remove DMO to reply

v-xuwen NO[at]SPAM online.microsoft.com
6/16/2006 1:50:03 AM

Hi George,

You can use oSql & T-SQL to backup MSDE database. Check following articles:

osql Utility
<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/c
p_osql_1wxl.asp>

BACKUP
<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts
_ba-bz_35ww.asp>

Backup/Restore Architecture
<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8
_ar_aa_9iw5.asp>

How to: Create a Full Database Backup (Transact-SQL)
<http://msdn2.microsoft.com/en-us/library/ms191304.aspx>

How to: Create a Transaction Log Backup (Transact-SQL)
<http://msdn2.microsoft.com/en-us/ms191284.aspx>

How to: Restore a Database Backup (Transact-SQL)
<http://msdn2.microsoft.com/en-us/ms189895.aspx>

Hope this helps.Let me know if you still have concerns.

Best regards,

Vincent Xu
Microsoft Online Partner Support

======================================================
Get Secure! - www.microsoft.com/security
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================

--------------------
[quoted text, click to view]
<4fda1pF1ihu18U1@individual.net>
<6B21622F-DAE8-4E56-B73F-EB57F9935B6C@microsoft.com>
[quoted text, click to view]
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!newsfeed00
.sul.t-online.de!t-online.de!newsfeed.freenet.de!fu-berlin.de!uni-berlin.de!
individual.net!not-for-mail
[quoted text, click to view]

Andrea Montanari
6/16/2006 3:04:40 AM

hi George,
[quoted text, click to view]

no offense at all.. it was just an idea to solve minor tweaks in easy way...
you can define and schedule a job, if you like, even via oSql.exe, the
command line tool provide by Microsoft along with MSDE... SQL Server Agent
will execute it at each schedule...

if you do prefere an OS solution, just create a file including the desired
backup statement and schedule it via AT/SCHTASKS to be run via oSql.exe as
well..
<bat or cmd file>
oSql.exe -E -S(Local) -Q"BACKUP DATABASE .... TO DISK = 'c:\...\....bak"
[quoted text, click to view]
</bat or cmd file>

see oSql synopsis in BOL for all parameters..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
--------- remove DMO to reply

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server msde

sql server msde : MSDE Backup