210 reputation
19
bio website
location Tampa, FL
age 34
visits member for 2 years, 11 months
seen Aug 7 at 20:24

profile for longneck on Stack Exchange, a network of free, community-driven Q&A sites


Jun
10
awarded  Yearling
Jan
12
awarded  Commentator
Jan
12
comment databasename_indx.ndf file not referenced but can't delete
@MartinSmith see edit above. sysaltfiles does reference the indx file.
Jan
12
revised databasename_indx.ndf file not referenced but can't delete
added 1316 characters in body
Jan
3
comment databasename_indx.ndf file not referenced but can't delete
Seriously? Rtfm? I get it, sql 2000 is old. Stop badgering me for trying to make the best of a real world situation. Why is the database dependent on a file that is not listed by sp_filehelp?
Jan
3
comment databasename_indx.ndf file not referenced but can't delete
Come on guys, give me a break. Of course I have that file. My point was that the file is not referenced as far as I can see but the database doesn't work if the file is gone.
Jan
3
comment databasename_indx.ndf file not referenced but can't delete
Like I said, legacy app. It's going away in 4 months when we get a new phone system. Until then, I make it work.
Jan
3
asked databasename_indx.ndf file not referenced but can't delete
May
14
answered Primary replica set server goes secondary after secondary fails
Apr
29
awarded  Citizen Patrol
Feb
22
answered Database mirroring - link failure between principal and witness
Feb
5
answered Using MySQL EXPLAIN to analyze the performance of a function
Jan
25
comment Transaction log for SQL Server is too big
I have found that I often had to run the BACKUP LOG command a couple of times before DBCC SHRINKFILE actually shrinks the file.
Dec
11
awarded  Teacher
Dec
10
answered Does Microsoft Security Bulletin MS11-049 affect SQL Server 2008 SP3?
Aug
20
accepted Is shrinking a transaction log OK to do on a live database?
Aug
20
awarded  Critic
Aug
20
comment Is shrinking a transaction log OK to do on a live database?
make your comment the answer and the rep is yours...
Aug
20
comment Is shrinking a transaction log OK to do on a live database?
Actually, my question has not been answered. I'm asking specifically if issuing dbcc shrinkfile causes the database to go offline or not. I am aware that regular shrinking is not a best practice. I am using the a shrink to fix an inflated log file after a long series of failed backups.
Aug
20
asked Is shrinking a transaction log OK to do on a live database?