January 19, 2010 at 3:15 am
I restored a full backup from an existings sql 2000 DB to sql 2005.
I checked the stored procedres and from 191 from the original, i got only 160;
I really dont understand what happens and what to do?
January 19, 2010 at 3:36 am
Check the creation date of those procedures in the source database and compare it with the Backup's date.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 19, 2010 at 3:43 am
the sp creation date is very prior to today backup
January 19, 2010 at 4:30 am
January 19, 2010 at 4:38 am
Are you using a backup file that contains few backups of the database? If you are doing a backup and pointing it a file that already exists and has an earlier backup of the database that you are backing up and you are not using the with init option, the old backups will still be available in the file. In this case when you run a restore statement if you don’t specify which backup to use, the server will use the oldest backup that exists in the file. If you still have the backup’s file that you used, you can check which backups it contains by running RESTORE HEADERONLY statement. It should show a record for each backup that it has.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply