Reputation
1,956
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
4 23
Newest
 Yearling
Impact
~75k people reached

Sep
18
comment How to monitor flat file for changes then run a SQL import job
How are you going to import the file? What facility are you using for the import?
Sep
17
accepted RESTORE failing with OS error 32, file being used by another process
Sep
16
comment RESTORE failing with OS error 32, file being used by another process
@SeanGallardy Well, it appears that you are correct and I was wrong on multiple counts. First, yes, it does need to list the logical names from the DB in the BAK file. And secondly, yes, I should have checked it more closely, because it failed when I tried that, because the original logical name had been misspelled (NBCC vs NBBC) and though I stared at it, didnt catch the spelling difference. If you can post this as an answer, I will accept it.
Sep
16
comment RESTORE failing with OS error 32, file being used by another process
I know what's in the backup set. It's a backup of a DB with the same name, but different instance and different logical names on the same server. I cannot use the logical file names from the BAK, that results in the error 'NBCC_Logistics_Model2_log' is not part of the NBBC_Logistics database.. The BAK file is of the correct database that I do want to restore over the existing DB. The question is how to get SQL Server to do it.
Sep
16
comment RESTORE failing with OS error 32, file being used by another process
@ShawnMelton No, I have checked for this.
Sep
16
comment RESTORE failing with OS error 32, file being used by another process
@MaxVernon again, as indicated above I have already done that. Nothing else has the BAK file open.
Sep
16
comment RESTORE failing with OS error 32, file being used by another process
@MaxVernon as indicated in the additional notes, I have already checked this. The db files specified are open by the recieiving DB. The file reported by the error message is open by the source DB in another instance on the same server.
Sep
16
comment RESTORE failing with OS error 32, file being used by another process
@ShawnMelton Yes, from a process local to the SQL Server instance. My account has local and domain admins.
Sep
16
revised RESTORE failing with OS error 32, file being used by another process
added 221 characters in body
Sep
16
asked RESTORE failing with OS error 32, file being used by another process
Sep
11
comment Possible to optimize SELECT query involving XQuery functions selecting from elements with arbitrary number of child elements
Have you tried adding an XMLschema?
Sep
4
comment SQL Server 2008 logging
Before we can proceed, we will need to confirm some things. So first, execute this query from a sql server admin account and add the results to your question post above: SELECT * FROM sys.traces.
Sep
4
comment SQL Server 2008 logging
And finally, my guess would be that this is the requirement that is generating the problem: stigviewer.com/stig/microsoft_sql_server_2012_database_instance/…
Sep
4
comment SQL Server 2008 logging
@KyleRogers OK, here's an interactive access version: stigviewer.com/stig/microsoft_sql_server_2012_database_instance/…
Sep
4
comment SQL Server 2008 logging
@KyleRogers in any event, you should be able to find other copies of it by Googling "SQL Server STIG"
Sep
4
comment SQL Server 2008 logging
@KyleRogers Not sure what to do about it, it works fine for me, both publicly and even from behind an oppressive corporate firewall. I can only assume that your current wifi is blocking it for some reason. You could try it with an explicit "http://" on the front: iase.disa.mil/stigs/app-security/database/Pages/sql.aspx
Sep
4
comment SQL Server 2008 logging
Two important points for everybody: 1) this is very unlikely to be about the SQL Server transaction logs, but rather about some form of Audit Logging. And 2) this is probably very similar to the SQL Server 2012 STIG located here: iase.disa.mil/stigs/app-security/database/Pages/sql.aspx
Aug
13
comment Why does transaction log continue to grow in Simple recovery mode with nightly backups
Actually, I have observed a similar phenomenon myself at one of my clients' sites databases with SIMPLE recovery model. The logs don't grow (yet, anyway), but the used space in the log files does grow by a tiny bit every night. And it happens when the database backup runs. I have not yet figured out what is causing it nor whether its a problem or not.
Aug
12
comment Is there any way to do a SELECT query without any optimization in SQL Server?
Why do you want the un-optimized speed of a query? What are you trying to figure out? (and Why?)
Jul
8
comment Database instance and database
This distinction ("Database Instance" vs. "Database") only applies to Oracle, AFAIK, and is related to Oracle's implementation model.