Reputation
220
Top tag
Next privilege 250 Rep.
View close votes
Badges
2 12
Impact
~9k people reached

Feb
12
awarded  Notable Question
Feb
10
awarded  Nice Question
Sep
30
awarded  Popular Question
Sep
24
awarded  Autobiographer
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?