Viewing 15 posts - 106 through 120 (of 217 total)
Hi,
I went through the Log shipping configuration in BOL..but it no where mentioned that the transaction log files will have the UTC date format by design for log shipping.
Could you...
August 20, 2009 at 12:21 pm
the restore latency comes into picture only if we schedule all the 3 jobs Backup, copy & restore at the same time?
Is above statement correct?
thanks
August 19, 2009 at 10:31 am
Lets say you leave them all running every hour.
Your backup starts at 1:00, your copy job at 1:15, your restore job at 1:30. 30 minute delay puts you outside 1...
August 18, 2009 at 10:32 pm
thanks for all inputs, its really helped a lot.
finally, can I just ignore the date format for transaction backup file taken by the log shipping backup job? or need to...
August 17, 2009 at 11:05 pm
thank you,
My conclusion from the results is..Log shipping backup job, giving time stamp to the .trn files as UTC data format, which is 7 hrs a head than the pacific.
Can...
August 17, 2009 at 3:43 pm
On both primary & secondary:
SELECT getdate(), getutcdate();
SELECT datediff(hour, getdate(), getutcdate());
SELECT dateadd(hour, 7, '20090817 08:00:01');
Results:
----------------------- -----------------------
2009-08-17 13:56:28.993 2009-08-17 20:56:28.993
(1 row(s) affected)
-----------
7
(1 row(s) affected)
-----------------------
2009-08-17 15:00:01.000
(1 row(s) affected)
August 17, 2009 at 2:53 pm
I did not understand what to do exactly regarding the time settings on the servers. Please see the attachment for the clock settings on both servers.
Select getdate() on Primary
Result:2009-08-17 10:34:12.193
Select...
August 17, 2009 at 11:34 am
pacific time (US)
August 17, 2009 at 12:12 am
after changing compatibility mode to 90 on Primary, we need to delete the databases on Secondary & reconfigure the Log shipping right?
August 16, 2009 at 10:08 pm
Hi DBA's, maintaing share point databases in SQL server 2005. Could you please answer my question regarding the backups considering Share point & SQL Server both involved?
August 14, 2009 at 10:31 am
Hi Sarab, Abhay,
Thanks for the detail explanation. I have noticed this memory paged out only when Cluster instance fail over to other node only so far..and I have the Max...
August 14, 2009 at 10:11 am
Hi,
Actullay I created virtual directories through Report Server Configuration manager as below
abcreportserver
abcreports
The request failed with HTTP status 400: Bad Request
But I'm able to connect Reportserver:
SQL1/ReportServer -...
August 13, 2009 at 10:25 am
Hi Gail,
I have a question here. In our company, Share Point admin is taking backups using Share point tools and I'm seeing in the error log on sql server that...
August 13, 2009 at 12:57 am
Viewing 15 posts - 106 through 120 (of 217 total)