Some like this:

RESTORE LOG (Database Name) from disk = 'path of .trn file'

WITH NORECOVERY

Use NORECOVERY Untill you are on the last LOG File, then replace WITH NORECOVERY with 'WITH RECOVERY'

Check the Log for the Date-time the error appeared and start applying all the logs Manually, until you are at the current stage.

This Error is due to the LSN, which...

Here is a catch, you can look in the and make sure the waittime column is low OR the waittype of the SPID is a latch waittype, so there should...

Or basic approach will be to use the Attach wizard available when you right click on +databases then click on Attach.

Look very closely to the File names and paths, they...

if your Datatype is a datetime type. then use this

select min(validatefromdata) from TABLEA

and select max(validatefromdata) from TABLEA

I figured out, what the issue might be.. but not sure.

here are the Datatypes for the Columns

[GLDCT] = char

[GLDOC] = float

[GLKCO] = char

[GLDGJ] = decimal

[GLJELN] = float

[GLLT] = char

[GLEXTL] =...

yes correct and Gila might be right, there might be user fault in here or a job or something... 🙂

yes sp_msforeachdb does the cursor thing check this:

use master

sp_helptext sp_msforeachdb

check this article only if you are using a clustered Terminal server

http://support.microsoft.com/kb/327270

Is the Database a full Backup or Diff backup,

did the Database have multiple Filegroups or Files.

Is there a case of Partitioned Tables

Are you restoring on same versions/editions.

What is the...

did you check for any spaces in the path(file path). SQL Server doesnot Like that. use some like this if you have spaces in your file path. c:\"program Files\Microsoft SQL".

Try this cursor option. I know coding with sp_msforeach db is possible. but this is another way to achieve the same results..

DEclare @sqlstm varchar(200)

Declare @dbname sysname

Declare rolldbname cursor for

Select...

Well, this is not a Database Admin Question, it is more of a general discussions and is not related to Database, unless you define the role of SQL Server 2005...

They are no system tables in SQl 2005, they are now DMV's

Try, select * from sys.all_views or sp_help sysprocesses if you need definition of the columns.

The sp_helptext wont work in...

Rebuild MSDB, but does that also delete your jobs and any DTS package information/Alerts and Mail information stored in the MSDB?

Check to see if you have enough Space in the...