July 27, 2001 at 12:21 pm
Hi all,
What is the backup file format for a full-backup. When I give a filename for backing up using the backup wizard, should I give an extension like .bak etc. Because, I found that the backup which I make, has no extension.
Kindly clarify
Cheers
Parasu
Parasu Raman
Regards
Parasu Raman
July 27, 2001 at 12:38 pm
No real format. Convention is .bak, but not requird. I have use .dmp before. Just be sure you remember what you use.
Steve Jones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 27, 2001 at 12:54 pm
Hi,
Thanx for that. When does my backup cannot be restored?
Can i backup in one server and restore it in another one. If yes, what should be considered.
Thanx again
Parasu Raman
Regards
Parasu Raman
July 27, 2001 at 3:54 pm
You can backup from one server to another. Depends a little on the SQL version.
For 7/2000, you can use the Enterprise Manager to restore the file, pick device and then find your file. You can restore to an existing database( overwrite) or a new database. Be sure you set the pack correctly. By default, the backup will contain the path on the original server. If this is a new server, the path may not be valid.
Steve Jones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply