0
votes
0answers
44 views

SQL Server 2014 Standard 2014 no access and bad preformance

My company looks after a server which is running SQL Server 2014 Standard Edition. The main application database on the server is replicated out to about 20 subscribers. The server has only been in ...
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
137 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 ...
0
votes
1answer
298 views

SQL Server on VMWare - is transaction log corruption possible?

Scenario: SQL Server 2005 or 2008, Windows 2008 OS. Running in a VM hosted on VMWare ESX server. Is there any known issue with VMWare when it caches pass-through write request and it never reaches ...
0
votes
1answer
221 views

A pseudo-Sql server to intercept and see all MySQL queries

I would like to setup a "pseudo-server" to intercept all the SQL queries made by my local application. The reason for that is that I can't administer the Mysql server, and it's difficult for me to ...
0
votes
2answers
788 views

Convert IP Address format from ForeFront Firewall logs with SQL

I am trying to query IP addresses from Forefront Firewall logs, and I am a little stuck on the IP formatting C0A8E008-FFFF-0000-0000-000000000000 Can anyone give me the MSSQL command to turn this ...
1
vote
1answer
773 views

SQL Server: How to make sqllogship.exe generate backup files with local instead of GMT files

When SQL Server log shipping generates transaction logs through a command like "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\sqllogship.exe" -Backup 60CD93F9-CFC2-4A84-8B06-3AD8DEADBEEF ...
1
vote
1answer
258 views

SQL Server 2008: how to add logins to database

I'm dbowner on certain database (my account is on public role on server login but dbowner role on certain databases). Now when I try to add logins from server logins, I can only see sa account and my ...
2
votes
6answers
531 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 ...
0
votes
1answer
1k views

How to log all sql going through JBoss datasource with log4j

I've looked at log4jdbc (which does not support datasources), p6spy which seems to be what I am looking for but it has not been updated since 2003 which makes me nervous and lists only JBoss 3.x (we ...
0
votes
1answer
46 views

What do I have to do to see the generated SQL with JBoss 6?

How can I make JBoss 6.0M2 show me the SQL that it generates and sends to the database?