Sign in
Microsoft.com
United States (English)
Brasil (Português)
Česká republika (Čeština)
Deutschland (Deutsch)
España (Español)
France (Français)
Italia (Italiano)
Россия (Русский)
대한민국 (한국어)
中华人民共和国 (中文)
台灣 (中文)
日本 (日本語)
香港特别行政區 (中文)
Resources for IT Professionals
Home
Resources for IT Professionals
>
Forums Home
>
Microsoft Research Forums
>
Developer Discussions
>
vb
Ask a question
Search Forums:
Search Developer Discussions Forum
Search All Microsoft Research Forums
Search All Microsoft Forums
vb
Monday, May 25, 2009 6:14 PM
hari_raj
0
Sign In to Vote
dears,
how to create back up for databases every week automatically?
pls do respond........
by
hari.....
Reply
Quote
All Replies
Thursday, July 23, 2009 8:12 PM
luisnike19
0
Sign In to Vote
Hi, it could be many ways to do this task, I think that the best way is to create a store procedure that makes this action.
BACKUP DATABASE DatabaseName TO DISK 'C:\backup.bak'
WITH FORMAT;
GO
then call that procedure when each week with VB.
Reply
Quote
Need Help with Forums? (FAQ)
© 2009 Microsoft Corporation. All rights reserved.
Terms of Use
|
Trademarks
|
Privacy Statement