June 9, 2005 at 3:15 am
Hi All,
I had to restore a SQLServer2000 DB from a Backup. Unfortunatly I discovered that the restored DB is missing all table relashionships. Within the backup wizard I cannot see any checkbox to ask for saving the them. How an I have the Table Relashionships saved when backing up a SQLServer DB? or maybe how to get them restored ?
Thanx a lot for any help.
Maurizio
June 10, 2005 at 11:45 am
I Think you restored an old version of your database.
In fact, when you do a backup, you have the option of adding or replacing existing backup copies on the same device (i.e. a file on disk).
Script :
Backup databse xyz to disk='c:\backup\mydb.bak' with NOINIT
OR
Backup databse xyz to disk='c:\backup\mydb.bak' with INIT
When you restore, if you use Enterprise Manager, view the contents of the backup file will list backup history. You can then choose the last backup.
HABIB.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply