Tagged Questions
0
votes
2answers
2k views
How to print out the query SQL text of a transaction by querying the “fn_dblog” or DBCC LOG('DataBaseName')?
At some point in the last 24 hours some changes were made to a customer SQL server 2008 (v 9.0 SP4) by one of a couple if possible applications that use the DB.
Its not particular critical, but it ...
0
votes
2answers
94 views
SQL Server build
We are building a new server at work and I'm hoping to get ideas of how we should build it out for optimum performance and back-up capability. We have 6 drives and we need to have an OS (Windows ...
1
vote
1answer
243 views
Oracle Linked Server query error
We have a problem with a query from a SQL Server 2008R2 - 64bit
to an Oracle Linked Server.
We use the Oracle 64-bit driver for Windows.
When we query a certain table we get the following error:
...
2
votes
1answer
106 views
Aborted restoring from back up Sql Server 2008
I started restoring from backup using (WITH REPLACE, RESTORE WITH RECOVERY)
and realized that it was a mistake, so I stopped restoring.
Now this db is unavailable and has a 'Restoring' status.
Can ...
7
votes
2answers
212 views
Mirroring the Distributor
Has anyone had success with mirroring the distribution database? We have a dedicated server as a Distributor. It handles all our push replication from prod to reporting. We'd like to build an ...
3
votes
2answers
300 views
Windows Storage Server, SQL Server, regular files — means to protect from insider threats?
This is my first post here, and I am by no means qualified as a Windows Server or Storage Server 2008 or SQL Server 2008 administrator. I am mostly a Unix guy, however tasked with a job to investigate ...
