944,134 Members | Top Members by Rank

Ad:
  • MS SQL Discussion Thread
  • Unsolved
  • Views: 19123
  • MS SQL RSS
You are currently viewing page 1 of this multi-page discussion thread
Oct 27th, 2006
0

How to Backup database - SQL Server 2000

Expand Post »
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
Similar Threads
Reputation Points: 58
Solved Threads: 1
Posting Whiz in Training
cancer10 is offline Offline
234 posts
since Dec 2004
Nov 7th, 2006
0

Re: How to Backup database - SQL Server 2000

Hi,
Attached is a zip file with the steps--hope it will be helpful
Attached Files
File Type: zip Backup.zip (247.9 KB, 1692 views)
Reputation Points: 10
Solved Threads: 0
Light Poster
sierrasoft is offline Offline
31 posts
since Nov 2006
Nov 7th, 2006
0

Re: How to Backup database - SQL Server 2000

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
Reputation Points: 58
Solved Threads: 1
Posting Whiz in Training
cancer10 is offline Offline
234 posts
since Dec 2004
Nov 7th, 2006
0

Re: How to Backup database - SQL Server 2000

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.
Reputation Points: 10
Solved Threads: 0
Light Poster
sierrasoft is offline Offline
31 posts
since Nov 2006
Nov 7th, 2006
0

Re: How to Backup database - SQL Server 2000

Any idea, wot extension they have?
Reputation Points: 58
Solved Threads: 1
Posting Whiz in Training
cancer10 is offline Offline
234 posts
since Dec 2004
Nov 7th, 2006
0

Re: How to Backup database - SQL Server 2000

doesn't have a file extension.
Reputation Points: 10
Solved Threads: 0
Light Poster
sierrasoft is offline Offline
31 posts
since Nov 2006
Nov 7th, 2006
0

Re: How to Backup database - SQL Server 2000

MS SQL DB Backups by default have the .BAK file extension.
Reputation Points: 12
Solved Threads: 6
Junior Poster
Geek-Master is offline Offline
156 posts
since Dec 2004
Nov 7th, 2006
0

Re: How to Backup database - SQL Server 2000

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.
Reputation Points: 58
Solved Threads: 1
Posting Whiz in Training
cancer10 is offline Offline
234 posts
since Dec 2004
Nov 7th, 2006
0

Re: How to Backup database - SQL Server 2000

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.
Reputation Points: 12
Solved Threads: 6
Junior Poster
Geek-Master is offline Offline
156 posts
since Dec 2004
Nov 7th, 2006
0

Re: How to Backup database - SQL Server 2000

I backup to an individual file
Reputation Points: 58
Solved Threads: 1
Posting Whiz in Training
cancer10 is offline Offline
234 posts
since Dec 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS SQL Forum Timeline: Database Backup Question (Newb :0)
Next Thread in MS SQL Forum Timeline: How do you count number of records in Sql?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC