Ville Lucander (5/4/2009)

changing to Bulk-logged would not have helped in this scenario. Updating existing column values is always logged. You can use bulk-logged when using bcp, select * into table...

Hello Ville

Thanks for the nice explanation. Appreciated.

GK

Hello

I am new to Sql Server 2008 bulk load (Oracle DBA entrusted with SQL Server now); Soon i will be dealing with 2TB of data /year ; 17GB/day assuming 365...

I tried the following query to identify the types of constraints i am having

SELECT c.status,count(*) FROM sysconstraints c

GROUP BY c.status

ORDER BY 1;

and it came up with

1331416

1336652529

1341776

But as per...

If i run "Setup" again ==> Installation Type ==> Add features to an existing instance of SQL Server 2008 , then

i am finding the "Feature Selection" components Greyed...

Does this mean i have to have more than one SQL Server instance running in the server (i.e) only one Reporting Server instance can be created against an SQL Server...

To clarify further, i want one more Reporting Server Instance against the Default SQL Server Instance.

To clarify further, i want one more Reporting Server Instance against the Default SQL Server Instance.

I am looking at a Web Application exposed to Internet with SQL Server as backend. Would appreciate if you can shed more light on it.

Thanks

Thanks a Bunch!!

Hi

Considering 6TB would be the volume of data/year, i am looking at about 18GB/day (540GB/month) and 6.480TB/year; We are planning to have log shipping; The problem with data loading is...

Thanks , it worked!! My Bad, i missed something so obvious.

One Correction. The ROWTERMINATOR in my posting should be '' (Backslash n); Somehow it got trimmed when i clicked the "Post Reply" button.

Ben H (9/25/2008)

- I recommend that you run this in a cluster to help protect against hardware failures.

- Why do you need logshipping with such a small delay? If you...

One correction to my earlier posting. This 15+ TeraByte db will have a Stanbdy with log shipping taking place (with 1 min lag);

Is there a way to reduce this...