Viewing 15 posts - 2,281 through 2,295 (of 5,394 total)
Decrypt from what encription?
December 1, 2011 at 4:38 am
Suresh B. (12/1/2011)
COPY_ONLY does not break the log chain.So if you have log shipping configured, you can use COPY_ONLY option to take a full database backup of testing, etc.
COPY_ONLY...
December 1, 2011 at 4:34 am
ps. (12/1/2011)
keep ur db in bulk logged recovery and then use bcp. this will be faster.
While exporting? Are you sure?
December 1, 2011 at 4:13 am
It's not a lot of data IMHO (I could be wrong, I guess lakths means 100.000).
SSIS would be the faster, BCP would work just as well.
December 1, 2011 at 3:47 am
DTS is old and deprecated. Use SSIS instead.
If this is a "one shot" operation, you can use the Import/export wizard or BCP.
Hope this helps
Gianluca
December 1, 2011 at 3:11 am
select *
from sys.dm_os_performance_counters
where counter_name = 'Total Server Memory (KB)'
Run this on all the instances and you'll get the whole picture.
December 1, 2011 at 3:10 am
SELECT *
FROM OPENQUERY(LSCTLRDAT1, 'SELECT * FROM PMSPYP00') AS RemoteTable
INNER JOIN MyTable AS LocalTable
ON RemoteTable.SomeKeyColumn = LocalTable.SomeKeyColumn
December 1, 2011 at 2:30 am
Are you using a linked server? Which OLEDB provider are you using?
Some things to check:
1) Isolation level
2) Two phase commit
3) Table journaling
What error are you getting?
Looks like you're...
December 1, 2011 at 2:10 am
alaguganesha1983 (11/29/2011)
Try replication between the two server.
Seems to me a bit of overkill for just a couple of tables...
November 29, 2011 at 2:13 am
Sorry it took me 6 months... :blush:
I posted a corrected version of this code on my blog:
http://spaghettidba.com/2011/11/28/email-alert-dbcc-checkdb/
I hope you will find it useful.
November 28, 2011 at 4:02 pm
No sysadmin privileges? No way to enable CLR AFAIK, sorry.
Talk to your provider, they may consent to enable CLR if you support your request with good points.
November 28, 2011 at 3:05 pm
Linked servers are good for small batches that involve little or no data movement.
SSIS is much more efficient when moving huge amounts of data.
November 28, 2011 at 3:02 pm
MysteryJimbo (11/28/2011)
This has an impact on replication as well.
Correct, but I don't see replication mentioned anywhere on this thread.
November 28, 2011 at 10:06 am
sqlfriends (11/28/2011)
What is the best way of doing this without using much space, I don't need the transaction log for this process.
There's no way to ignore or discard the transaction...
November 28, 2011 at 9:53 am
Sean Lange (11/28/2011)
November 28, 2011 at 9:18 am
Viewing 15 posts - 2,281 through 2,295 (of 5,394 total)