Viewing 15 posts - 526 through 540 (of 1,539 total)
These URLs should help you:
http://www.sqlservercentral.com/Forums/Topic342644-7-1.aspx
http://sql-server-performance.com/Community/forums/p/27963/150413.aspx
August 20, 2009 at 10:09 am
You dont need to have same account!!
Account used on primary should have write access to the shared folder, where as the account used by secondary should have read permission on...
August 20, 2009 at 10:03 am
ShekharNaidu (8/19/2009)
(Log shipping and Transactional replication are not applicable to this situation)
What is the constraint you have when u say you cannot implement log shipping on this situation?
August 20, 2009 at 9:53 am
MAK (8/20/2009)
How to run the log reader
If you're using pull subscription, the log reader job would be created on the subscriber, if you've setup push subscription, the job will be...
August 20, 2009 at 9:48 am
kevinH (8/20/2009)
you still have a single point of failure on the drives unless you do something extra there.
You're right but usuallly the shared disks array are fault tolerant(SAN/NAS)...
August 20, 2009 at 9:42 am
kstjacques (8/20/2009)
DECLARE @body2 VARCHAR(1000)@body2= SELECT * FROM myTable
WHERE myValue >= 3
AND myTime >= DATEADD(minute, -1, GetDate())
May be there are more elegant ways of doing it, what i can think...
August 20, 2009 at 9:27 am
ekonagu (8/19/2009)
size of db wil be 5 gb and down time can be 30 min
I suspect you're confused between the downtime duration and amount of allowable data loss....
August 19, 2009 at 7:34 am
probably in sql server, you detach the database and back it up to another device and this should be equivalent of cold backup in oracle.
August 19, 2009 at 7:24 am
Silverfox (8/17/2009)
Isnt India the main supply of outsourcing... and isnt its economy very much IT based.
Agriculture still accounts for 60% of employment, followed by the service industry which accounts...
August 18, 2009 at 8:12 am
HCL is an indian company providing IT outsourcing services.
August 18, 2009 at 7:49 am
may be the OP is trying to create some script. I'm doubtful though....
August 17, 2009 at 5:36 am
I'd worked with AIG which used to be the leading insurer (and re-insurer). I didnt have idea of insurance domain when i joined but gradually i did come to know...
August 16, 2009 at 6:29 am
you can query fn_dblog undocumented command to browse through the transaction log to find out when it was last run. I'm unaware about the exact search string for checkpoint but...
August 16, 2009 at 6:24 am
Viewing 15 posts - 526 through 540 (of 1,539 total)