•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 397,810 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,523 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 7771 | Replies: 11
 |
| |
•
•
Join Date: Dec 2004
Location: India
Posts: 234
Reputation: 
Rep Power: 4
Solved Threads: 0
Posting Whiz in Training
How to Backup database - SQL Server 2000 Hello,
I was looking around for some tutorials about how to backup my database in my hard disk using SQL Server 2000 Enterprise Manager.
Can someone explain me in a friendly and step-by-step method? (screenshots preferred)
Thanx so much in advance
I was looking around for some tutorials about how to backup my database in my hard disk using SQL Server 2000 Enterprise Manager.
Can someone explain me in a friendly and step-by-step method? (screenshots preferred)
Thanx so much in advance
•
•
Join Date: Nov 2006
Location: Nasik-India
Posts: 21
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
Re: How to Backup database - SQL Server 2000 Hi,
Attached is a zip file with the steps--hope it will be helpful
Attached is a zip file with the steps--hope it will be helpful
•
•
Join Date: Feb 2007
Location: Indonesia
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
:rolleyes: Thanks, thats the ordinary way to create backup with sql2000 feature. What i mean is how to run the backup feature with the vb6 code.]
•
•
Join Date: Dec 2004
Location: India
Posts: 234
Reputation:
Rep Power: 4
Solved Threads: 0
Posting Whiz in Training
Thanx,
One more question,
After I perform a backup, how do I burn the backup file in a CD? I mean I cannot see a file with the name I provided, its hidden or something?
Thanx
One more question,
After I perform a backup, how do I burn the backup file in a CD? I mean I cannot see a file with the name I provided, its hidden or something?
Thanx
•
•
Join Date: Nov 2006
Location: Nasik-India
Posts: 21
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
No--the file will be on the drive specified e.g D:/ --with the name that you have specified in the Add dialog box-(Image 3 in the file sent previously)-e.g Backup. Once you have found the file--burn it to the CD.
•
•
Join Date: Dec 2004
Location: India
Posts: 234
Reputation:
Rep Power: 4
Solved Threads: 0
Posting Whiz in Training
Any idea, wot extension they have?
•
•
Join Date: Nov 2006
Location: Nasik-India
Posts: 21
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
doesn't have a file extension.
•
•
Join Date: Dec 2004
Location: Hiawassee, Georgia
Posts: 129
Reputation:
Rep Power: 4
Solved Threads: 1
Junior Poster
MS SQL DB Backups by default have the .BAK file extension.
If in doubt, reach into the trash can and remove the user guide.
•
•
Join Date: Dec 2004
Location: India
Posts: 234
Reputation:
Rep Power: 4
Solved Threads: 0
Posting Whiz in Training
I searched my C:\ drive both by file name (that I provided while backing up) as well as *.bak but could not any such files. any idea?
PS: Backup was done successfully.
PS: Backup was done successfully.
•
•
Join Date: Dec 2004
Location: Hiawassee, Georgia
Posts: 129
Reputation:
Rep Power: 4
Solved Threads: 1
Junior Poster
Do you backup to a "backup device" or to an individual file? A backup device will store several backups into one file and that could be a reason you can't see your recent backup.
If in doubt, reach into the trash can and remove the user guide.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Hybrid Mode
•
•
•
•
ad advertising ajax architecture asp avatar backup breach business centro crash daniweb data protection database dell design developer development doubleclick enterprise google government hacker ibm internet linux longhorn mail medicine microsoft mmorpg msdn news normalization novell office open qmail red hat rhel security server smtp software sql survey suse vista windows windows server
- Reading logs in MS SQL Server 2000 (MS SQL)
- Developing SQL Server 2000 (MS SQL)
- Attach the desired database - SQL Server - Setup Factory 7 (MS SQL)
- sql server 2000 on win-xp pc (MS SQL)
- SQL SERVER 2000 Login failure in ASP.NET (ASP.NET)
- Ms Sql Server 2000 (MS SQL)
Other Threads in the MS SQL Forum
- Previous Thread: Database Backup Question (Newb :0)
- Next Thread: How do you count number of records in Sql?
