Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

logshipping is Any difference 2000 and 2005?

Question Posted / prasadhari_m@yahoo.com

Answers were Sorted based on User's Feedback



logshipping is Any difference 2000 and 2005?..

Answer / srinivasa ganamur

Hi,

In 2000 : Log Shipping require Enterprise Edition.Expensive
hardware.

In 2005 : Log Shipping available in Standard Edition.cheap
hardware.

Regard's
Srinivasa Ganamur

Is This Answer Correct ?    5 Yes 2 No

logshipping is Any difference 2000 and 2005?..

Answer / patel

Log shipping is not depending on any hardware.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Diffrences between sql server 2000 vs 2005

2 Answers   Thomson Reuters,

What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

hi to all teachers,... Friends who write in the query mode Full text Search in Sql Server have experience Who make(Convert) this Stored Procedure as a normal Full text Search, which contains and .. Is used, into Advance of the tips I have thanked all friends perfection. Email : rezaafandi@yahoo.com Create PROCEDURE Sp_student @fname varchar(50), @lname varchar(50), @tel varchar(50), @code varchar(50), @adr varchar(50), @search_operation varchar(50), @totalRowCount bigint output AS begin if @search_operation = 'and' begin SELECT f3,f4,f5,f6,f7 FROM tb_student WHERE( f5 like '%' + @fname + '%' and f4 like '%' + @lname + '%' and f6 like '%' + @tel + '%' and f7 like '%' + @code + '%' and f3 like '%' + @adr +'%' ) select @totalRowCount = @@rowcount end

0 Answers  

Why Master database is required?

0 Answers   Abacus,

How to compare the top two records using sql?

0 Answers  




Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

0 Answers   MCN Solutions,

How many categories of data types used by sql server?

0 Answers  

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

0 Answers  

How to create a trigger for insert only?

0 Answers  

how to find number of columns in a table in sql server 2000 and 2005 also

16 Answers   Virtusa,

How to perform key word search in tables?

0 Answers  

Name few of the dcl commands in sql?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories