In query analyzer type backup and look it up in books online for a more advanced overview.
The short answer... >From sql books online: -- Back up the full MyNwind database. BACKUP DATABASE MyNwind TO MyNwind_2 -- Update activity has occurred since the full database backup. -- Back up the log of the MyNwind database. BACKUP LOG MyNwind TO MyNwindLog1 ----- Original Message ----- From: "pinky p" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, September 12, 2005 5:56 AM Subject: Re: [AspNetAnyQuestionIsOk] Database BackUp > Hi > Wanted a code which can take a BackUp of a particular > database. > Database = SQL Server 2000 > > Thanks in Advance > > > > > > > > > ______________________________________________________ > Yahoo! for Good > Watch the Hurricane Katrina Shelter From The Storm concert > http://advision.webevents.yahoo.com/shelter > > > > > > Yahoo! Groups Links > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
