Showing posts with label space. Show all posts
Showing posts with label space. Show all posts

Friday, March 23, 2012

Maintenance Jobs Failed

Hi
Recently I have moved sql 2005 from one box to another with bigger hdd space and more memory. Since then I am getting the attached error message when I Execute all the job.Hey Common Gurus Help Me out... since 24 hours no reply
Thanks|||Resolved the issue.. thanks...|||Can you please post your resolution?|||Follow the link, has complete solution...

http://support.microsoft.com/kb/903205sql

Monday, February 20, 2012

LSN Error

detached a db and its log to move to a drive that had more space. When I
wwent to reattach it, it fails and I went to the SQL Log and get the follwing
error:
The LSN (383:476:1) passed to log scan in database 'DBName' is invalid..
HI
Modify default log directory to new log file location (temporarily) on
server database settings.
Use sp_attach_single_file_db
Restore default log directory as need.
Andras Jakus MCDBA
"DBA" wrote:

> detached a db and its log to move to a drive that had more space. When I
> wwent to reattach it, it fails and I went to the SQL Log and get the follwing
> error:
> The LSN (383:476:1) passed to log scan in database 'DBName' is invalid..
>

LSN Error

detached a db and its log to move to a drive that had more space. When I
wwent to reattach it, it fails and I went to the SQL Log and get the follwing
error:
The LSN (383:476:1) passed to log scan in database 'DBName' is invalid..HI
Modify default log directory to new log file location (temporarily) on
server database settings.
Use sp_attach_single_file_db
Restore default log directory as need.
Andras Jakus MCDBA
"DBA" wrote:
> detached a db and its log to move to a drive that had more space. When I
> wwent to reattach it, it fails and I went to the SQL Log and get the follwing
> error:
> The LSN (383:476:1) passed to log scan in database 'DBName' is invalid..
>