September 28, 2006 at 1:39 am
Hi,
I took the backup of a database throught EM and restored on the same server. After restoration, what i observed is some procedures,tables and columns are missed in the new database. The application is running on Linux and database connecting to sql server 2000. This is happening for some databases.Any Ideas?
Thanks in Advance
Ramaa
September 28, 2006 at 2:56 am
Rama,
Exactly which tables appear to be missing in the restored databases do they all start with the letters sys? Are the Linux applications working as expected?
To get a really good comparison between databases (assuming you didn't restore over the top of the exisiting databases) try downloading the trial version of SQL Compare from Red-Gate http://www.red-gate.com/products/sql_compare/index.htm
ll
September 28, 2006 at 2:57 am
- what was the timegap between the backup and the restore ?
- have these procs, .. been created/altered during your backup ? (open transaction will be rolledback during recover)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 28, 2006 at 4:39 am
Hai alzdba & Journeyman,
Those tables are user tables they start with different letters.Linux application is working fine.
There was no time gap. Just i took the backup and restored the database and exported some data from another database.
Just now i observed one column is missed
when trying to insert some data through the application.I am doing disable and enable the table constraints before importing the data.what was the wrong?
Ramaa
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply