Backup of All Database

ASP Free Forums Sponsor:

September 28th, 2004, 01:47 AM

hksahu

Registered User

Join Date: Sep 2004

Location: Orissa, India

Posts: 7

Time spent in forums: 1 h 45 m 22 sec
Reputation Power: 0

Backup of All Database

Hi Dear All,
we are using SQL Server as our backend database. for that we need to take regular backup of all the databases present in SQL Server. Now i am going to each and every database and i am choosing Backup database for all the databases, which i have to do manually. For taking backup can we write any script or can we schedule a task so that at that particular time it will automatically backup the database and store in a particular path.

Thanks & Kind Regards,
Harekrushna

September 28th, 2004, 07:32 PM

spungebob

Contributing User

Join Date: Feb 2004

Location: Dover

Posts: 128

Time spent in forums: 1 h 39 sec
Reputation Power: 5

DB Maintenance Plan

You need to create a "DB Maintenance Plan" this is found under "management" in SQL Administrator.

Viewing: ASP Free Forums > Database > Microsoft SQL Server > Backup of All Database

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump