June 5, 2008 at 2:48 pm
When I use LiteSpeed 4.8.4 to backup a database in SQL 2005, I got the following error. I could see the backup file of the database. From the message below, it seems that the database had successful backup. But what is wrong at the end of this message?
Any input will be greatly appreciated.
BACKUP DATABASE successfully processed 967 pages in 0.239 seconds (33.145 MB/sec).
Backup added as file number: 1
Native Size: 9.63 MB
Backup Size: 1.62 MB
CPU Seconds: 0.34
Environment: Intel(R) Xeon(TM) CPU 3.40GHz
CPUs: 2 logical, 2 core(s), 2 physical processors(s).
Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'master..xp_getfiledetails'.
June 5, 2008 at 3:41 pm
The extended stored procedure xp_getfiledetails no longer exists in SQL Server 2005. I just double checked my servers (I have both SQL Server 2000 and SQL Server 2005 still) and it is on the SQL Server 2000 systems, but not the SQL Server 2005 systems.
Looks like Litespeed used it for something, but they haven't updated the software to account for its loss in 2005.
😎
June 5, 2008 at 10:32 pm
[font="Verdana"]Hi,
This version of Litespeed supports SQL 2005 also, refer [/font][font="Courier New"]LiteSpeedSQL_484_ReleaseNotes_en. [/font]
[font="Verdana"]
It looks like dependency on extended SP xp_getfiledetails, hence it's better to contact Litespeed support to resolve.
MS has removed xp_getfiledetails SP in SQL2005, refer [/font][font="Courier New"]Extended SP[/font] link
Regards..Vidhya Sagar
SQL-Articles
June 6, 2008 at 2:27 pm
You guys are right. I used the old version of stored procedures for SQL 2000 in SQL 2005.
Now, the problem is solved.
Many thanks for your input.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply