>You have left some information out, so here are a few questions.

>What does the database design look like? 15tb is a lot different if there is one very large...

Replies embedded

>- Use a 64bit Enterprise environment

>- Use a SAN with a lot of disks

>- Which backup solution are you gonna use? (backuptime, duration, restore strategy)

As of now ,...

Thanks for the quick turnaround Gail

GovindanK

gk (4/7/2008)

---

Hello

I am trying to generate SQL statements to apply the backlogged Transaction logs. To do this , i am looking at the following System tables

log_shipping_monitor_alert (Transact-SQL) =>...

Finally i came across this link which i found useful. Thought i will share this with the forum.

http://www.sqljunkies.com/Article/4E65FA2D-F1FE-4C29-BF4F-543AB384AFBB.scuk

Thanks for all the suggestions.

It does not matter if this is Oracle or Sybase related. The question is how to get the answer.

Andras Belokosztolszki (3/14/2008)

---

dbcc...

Good question. I did not notice to that extent. Next time i do switch over i will look at it. The suggestion i got is that delete from log_shipping_monitor_history_detail. Currently...

Thanks to all who responded.

I found the following query useful.

select database_name, backup_finish_date

, type, [name], user_name, first_lsn, last_lsn, * from backupset

where database_name = 'YOUR_DATABASE_NAME_HERE'

order by 2

But still how to find if...

Found answer to Question 2 .

"backupset" is the view (in msdb)

select database_name, backup_finish_date

, type, [name], user_name, first_lsn, last_lsn, * from backupset

where database_name = 'YOUR_DATABASE_NAME_HERE'

order by 2

But this doesn't seem...

This is SQL Server 2005 CE ; it says ''sp_get_log_shipping_monitor_info" does not exist; I tried in master and the primary database.

Hello Ronda

How do you mail / page the dba. There is no mailx equivalent in windows AFAIK. Would you mind sharing the script you are using?

Thanks

The problem was starting the SQL Server Service Manager with the wrong exe/directory. Now it is solved. Thanks for all those who responded.

Would appreciate if someone can answer my questions. Thanks

Liam

Thanks for your suggestion. But i am getting the same error.