166 reputation
18
bio website Google.com
location Google
age
visits member for 2 years, 2 months
seen Sep 18 '12 at 8:00

Sep
11
comment Mirroring - Server network address cannot be reached
Verify that 5022, 5023 and 5024 are listening. Yes it is listening. Verify that the server name you are using is correct. Yes it is correct.
Sep
10
comment Mirroring - Server network address cannot be reached
I will get back to you very soon. +1 for the help.
Sep
7
comment Does Log-Shipping need Transaction Log Backup from Primary Server?
I guess technically you could argue that you shipped the log once, but the point of log shipping is to keep the secondary server up to date more often than the full backups (which are typically very large in comparison to periodic log backups). I just restored Full Backup and not the Transactional Log Backup and still it is updating the secondary database as per the schedule. I set it to 2 mins..as it contained just a table.
Sep
7
comment Does Log-Shipping need Transaction Log Backup from Primary Server?
Initialize the logshipping
Sep
7
comment Does Log-Shipping need Transaction Log Backup from Primary Server?
If you don't include the transaction log, then it's not really log shipping, is it? It is happening
Aug
30
comment SQL Server index / performance help needed (index scan and a sort taking 40 minutes)
Actually he is talking about 48 million rows. I had same issue before. I took same initiative (involved temporary tables). But this caused the situation worst. Why? The Hard Drive started to occupy 22GB space in a week due to .ldf file . In know this will fix the issue but temporarily.
Aug
30
comment SQL Server index / performance help needed (index scan and a sort taking 40 minutes)
Temp table can easily increase the log file very quickly?