ps (6/16/2009)

---

murthykalyani (6/16/2009)

---

Find out which log backup file is failing, restore that log manually with move and norecovery option, once that is restored, please restart restore job, this should...

Find out which log backup file is failing, restore that log manually with move and norecovery option, once that is restored, please restart restore job, this should fix your...

Please post entirey history of log shipping restore job for it's last run for the database that you are having issue.

[Quote]

I had set up the following counters and Iam posting some sample data. But I am unable to figure out that reading were <20ms?

how can I make sure it is...

Sorry didn't see your post and responded

Substitute data with field name please remove quotes.

If you want in US standard i.e mm/dd/yyyy then

select convert(varchar(10),'01/01/2009 12:00:00 AM',101)

if...

rambilla4 (6/3/2009)

---

We have all the drives including C drive on SAN.

If SAN being shared then it has to be figured out what is causing that these messages recorded in error...

rambilla4 (6/3/2009)

---

Hi,

I have noticed the below message in the error log:

2009-05-27 20:22:24.95 spid2s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on...

Given below link explains you how to migrate logins and password.

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

bubbly (5/28/2009)

---

I have a list of jobs in application server which are being used by the application team..the jobs access the databases from the production server(only system databases are present...

Here is the script which gives you all the information that you are looking for.

set nocount on

if object_id('tempdb..##temp_schedule') is not null

begin

drop table ##temp_schedule

--print '##temp_schedule table dropped'

end

if object_id('tempdb..#temp1') is not null

begin

drop...

Can't you filter and fetch data from oracle through open query and then join required data or do you want to do join on entire data with out filtering?

there are...

Because the content database size is 70 GB now and it will grow to 150GB in few months.So, creating multiple datafiles will improve performance right? thats I want accomplish.. I...