The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
91 views

PostgreSQL Page-level locking

I'm fairly new to postgresql. I've checked out the documentation and I can't find anything about how to do page-level locking. I understand that I can set a table into a locking mode like this: LOCK ...
1
vote
1answer
69 views

Seeking Opinions - Is it a good idea to rely SQL backup 100% on transaction logs? [closed]

I'm in the midst of changing my company's SQL Server backup practice. We use to create full backups weekly and daily differential backups overnight. The issue is that as these full backups grow, it ...
1
vote
3answers
136 views

How frequent can we do SQL transaction log backups?

I'm installing a highly critical system. If the system fails, the users wants data up to the last minute. To achieve this, I was thinking of running Transaction Log Backups + FTP every minute. Has ...
1
vote
2answers
628 views

Transaction log full issue with SQL Server 2008 R2

I am running into 'transaction log full' issue with SQL Server 2008 R2. My database includes 80,000 tables which contains up to 5 columns of BIGINT and there is an index for each columns. The ...
0
votes
1answer
672 views

Yum Transaction Check Error on install

# yum install subversion subversion-devel neon neon-devel While trying to install some packages with yum – as shown above – I get the following error Transaction Check Error: file ...
1
vote
2answers
271 views

How much memory does one Postgresql savepoint take up?

How much memory does a single savepoint (within a transaction) take up in postgresql? I'm developing an application which might create a significant amount of savepoints (100k+) and was wondering ...
1
vote
2answers
106 views

need scalable, highly available transactional log server

My requirements: 1) must be able to continue operating after node failure 2) logs must be recoverable after node failure - no data loss 3) must be able to scale out 4) must be transactional - when a ...
2
votes
6answers
517 views

SQL Server transaction log backups,

I have a question regarding the transaction log backups in sql server 2008. I am currently taking full backups once a week (Sunday) and transaction log backups daily. I put full backup in folder1 on ...
2
votes
1answer
152 views

Snapshot transaction Isolation levels: it really works as advertised?

Have you any problems using it on high concurrency environment? It's really works as advertised by MS? I'm using SQL Server 2005 and would like to hear the experiences of those who are/was using it on ...