keepintouch2b (4/11/2011)

---

For SQL Server 2005, use restore to another instance will not work b/c of the LSN error mention on my prior replied post.

For SQL Server 2008 or Denali, I...

Sounds as though you want to use the restore function to manipulate data ... that's the opposite of it's purpose. A restore is designed to bring a database back to...

Step 7 sounds like you want to apply an old transaction log backup to a newer database. That won't work, or am I misunderstanding ?

Probably some other process has a lock on the index. Are you running the maint plan during off-hours ?

Basically, the transaction log contains the database activity that has occured since the previous backup (full, diff or tran log)

Proper explanations & details here:

http://www.sqlservercentral.com/search/?q=gilamonster&t=a

I think the total size of you t-log backups should be about the same. One huge daily backup, or many small 20 minute backups.

And if only have SQL Express, you can use shareware SQLScheduler to create jobs.

Our production transaction logs are backed up every 15-20 minutes.

The frequency is determined by your businesses allowable data loss.

Transaction backups once per day means you have the potential to lose...

Why do you use 2 different accounts on the forum ? I see others do it once in a while .... seems confusing all around.

If it is a production database I would suggest something like:

1) Set to FULL recovery model

2) Take one-time full backup now to re-establish log chain

3) Take full backup daily

4) Schedule...

I assume you checked the obvious that your variable for the database name is long enough ?

The truncated name is 50 characters long.

Are you using proper 4 part name ?

select * from Server1.Database.dbo.table

Perhaps it has to do with how you are setting your parameters ?

I found this at the following link

http://social.msdn.microsoft.com/Forums/fi-FI/transactsql/thread/bcd99cba-240d-4f5e-87fe-9780ed50d5e4

The meaning of the error message is that if you say:

EXEC my_sp...

What is @name ?

The query you posted above works for me with the double quotes.

I think you need double quotes around your literals:

FROM sys.dm_exec_requests r WHERE command IN (''RESTORE DATABASE'',''BACKUP DATABASE'')',