February 9, 2006 at 1:03 pm
Hi!
I've maybe a very curios problem. A patched the server (MS-SQL2000) with the sp4 a couple of time ago, my datafiles are on a different drive. Now i've to restore the image of the drive with the server. But the SP4-Batch is not on the image. Can i reinstall the sp4, even the master-db has been already patched with sp4? Will there be any problems? Is it possible to save the database before i path the sql-server and restore the database after it?
Thanks a lot, Martin.
February 13, 2006 at 10:00 am
I am kind of confused here. So you've already applied SP4 to your instance and you had to restore you data files for a user database? When you apply a service pack, it gets applied to the instance of SQL Server. Given this, you do not need to re-apply the service pack. Just restore your data files for your user database and attach then to your SP4 instance. to prove this, run SELECT SERVERPROPERTY('ProductLevel'). This will return your service pack level. If you have applied SP4 than this command will show SP4. Run this again after attaching your restored data files. The command will still return SP4.
February 14, 2006 at 5:30 am
Hi!
No, i had to restore the system from a image, at which i didn't have patched the sql-server. But the masterdb (which is on another volume) had already been patched.
In the meanwhile i've done it, with restoring an old database (without sp4), upgrading the sql-server with sp4 and then restoring the 'new' database. It seems, that it worked fine.
Thanks, Martin.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply