ࡱ > ~ } 5@ bjbj22 X X ^ 0 0 0 D 8 4 D r T T ( | | $ b R | 0 " | U , l l l R | 0 l l $ l : Y , " 0 H ) 4 $ B 0 r 0 @ 0 D D 0 0 l + 7 D D P D D How To Make A One Time Backup Dump Of A SQL Database WinSales Versions: All Revised: 11/2/01 Support Document: sup030 This document contains instructions for taking a SQL Server 6.5 database and creating a dump of the data that can be used for backup. This same process can be followed with some variation in SQL Server 7.0 and 2000 using the Data Transfer Services. Open SQL Enterprise Manager and open the SQL Server folder. Select the Backup Devices folder. Right click to choose New Backup Device. Give the file a name (something descriptive like SilentPartner091401). The location of the .DAT file will default (though can be changed). Select Disk Backup Device for the option of disk or tape. Go to the Database folder and open to see the list of databases. Select the database you want to dump and right click to select the option to Backup/Restore the database. Choose the Backup Device created above and click the Backup Now button to create the .DAT file specified above. FILENAME \p C:\tempTechnotes\sup030.doc Last printed PRINTDATE 6/17/1999 8:12 AM Silent Partner, Ltd 425-831-7915 HYPERLINK "mailto:support@winsales.com" support@silentpartner.com www.silentpartner.com 7 9 } } X f & ' 2 3 D E H i ȻȻȻȬȬȻȬȬȜȖ||xj hoD CJ OJ QJ ^J aJ h{ h{ h mH nH u j h{ Uh h{ h h{ CJ j h{ CJ OJ QJ U^J h{ 5CJ OJ QJ \^J h{ 5CJ OJ QJ ^J h{ CJ OJ QJ ^J h{ 6>*CJ OJ QJ ]^J 6j h{ 6>*CJ OJ QJ U]^J hmH nH u$ % 7 8 9 P a z { | } w x F G H \ i $a$gdoD $ !#a$ h^ `h 7$ 8$ H$ H i j h{ CJ OJ QJ ^J h{ hoD h{ hoD hoD 0J CJ OJ QJ ^J aJ hoD CJ OJ QJ ^J aJ #j hoD CJ OJ QJ U^J aJ h^ `h gdoD # 0 P / =!"T#$% n^u #N_(]PNG IHDR R 7Y gAMA pHYs + IDATxˏeUƿo}N=c[PD ,bƈ)Ab !/ )BHQ&LB@By8qmU]`{vUݿjխ:Z{.JBX%n@Ѹ47+G^;ՎFq,n{dhMdhMdhMdhMdhMdhMdhMdhMdhMdhMdhMdhԻ]#xg9Wq+R9S,Duזve~qaUtZ̿~ǧ6zqw]3gǙx#9u~lnAˑŞΓ#Wk \/.۳d:,mG;8 ggt`&|LTtܝo[ȁ+ǵ_Ҫ=e_[@_nYI$U/_ ,K-ÁwoޓpC,8Isyڛw7>nz$DžNNU-?UO5Xs3GGv j^yq㧭h9g:|ᴏpt7*8BVqnM\c^ q{=@}t|ҸgiA~ާƪdhMq&?OwE hF .df@R#N L. 3@0qu Fr3mY P