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

Jul
18
awarded  Notable Question
Oct
18
awarded  Popular Question
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
Sep
7
asked Mirroring - Server network address cannot be reached
Sep
6
awarded  Student
Sep
6
revised Does Log-Shipping need Transaction Log Backup from Primary Server?
edited tags
Sep
6
asked Does Log-Shipping need Transaction Log Backup from Primary Server?
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?
Aug
30
revised Placing Transaction Log on Separate Volume [solid state]?
Signatures not allowed as mentioned here http://dba.stackexchange.com/faq#signatures
Aug
30
suggested suggested edit on Placing Transaction Log on Separate Volume [solid state]?
Aug
30
awarded  Citizen Patrol
Aug
29
awarded  Supporter
Aug
29
revised Database Mail Issue
Signatures not allowed
Aug
29
suggested suggested edit on Database Mail Issue
Aug
29
revised Improve performance of a Fact Table
added 2 characters in body