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
Showing posts with label space. Show all posts
Showing posts with label space. Show all posts
Friday, March 23, 2012
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..
>
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..
>
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..
>
Subscribe to:
Posts (Atom)