Viewing 15 posts - 136 through 150 (of 2,008 total)
Those are HA/DR, not backups. They're great for HA/DR, but pretty useless when you need to get last night's data.
I have another question now. Does it mean HA/DR will not...
February 13, 2012 at 7:05 am
So, your 1TB database may have 1TB of data within, in which case, yes, your backup is 1TB in size, but if it has less data, then the backup is...
February 13, 2012 at 6:53 am
Does it mean 1 TB database will have ~1 TB backups (FULL, without compression)? Let me add 2 DIFF backups (100 GB each) and few LOG backups (up-to 300...
February 12, 2012 at 4:22 am
GilaMonster (2/12/2012)
Dev (2/12/2012)
Why are you so surprised?
Tell me exactly how a 400 GB database will generally have a full backup of under 100GB (and note that backup compression...
February 12, 2012 at 3:55 am
This is what I said...
I must agree with Joe this time. I understand his example & serious consequences if OP’s case follows the same pattern.
I know OP has already declared...
February 12, 2012 at 3:44 am
OLE DB Source in SSIS:
http://msdn.microsoft.com/en-us/library/ms141696.aspx
Limitation:
The Microsoft OLE DB provider for Oracle does not support the Oracle data types BLOB, CLOB, NCLOB, BFILE, OR UROWID, and the OLE DB source cannot...
February 12, 2012 at 3:24 am
Did you read the articles I suggested to you?
Please execute the following on Test server and see it yourself how it works.
set nocount on
Print 'table created'
create table some_table
(
...
February 12, 2012 at 3:16 am
This article would be helpful to you.
SQL Server 2000 to 2008 Upgrade - Microsoft
February 12, 2012 at 2:43 am
I don’t think it’s an issue with application (however it can be). Most of the times database upgrade 2000 -> 2008 performs slow if not properly done.
Can you please provide...
February 12, 2012 at 2:40 am
Whatever you do, just don’t mess-up with shark... :Whistling:
February 12, 2012 at 2:36 am
Do you have a database of 400 GB? In general, its FULL backup won’t cross 100 GB size.
Can you please explain how your database files are distributed on I/O subsystem...
February 12, 2012 at 2:29 am
Please don’t rush to implement the solution on PROD server if you are not confident enough. If you miss on any step, you should know how to overcome the issue.
On...
February 12, 2012 at 2:25 am
...if you want to move a table from A to B, on SQL Server you would probably use SSIS while on Oracle you would either use a dblink or expdp/impdp.
Other...
February 12, 2012 at 2:20 am
Service Broker is a big chapter in itself so if you are interested in learning something new, please use it. It’s very good utility in SQL Server.
Trigger approach would be...
February 12, 2012 at 2:07 am
Viewing 15 posts - 136 through 150 (of 2,008 total)