210 reputation
111
bio website
location Tampa, FL
age 34
visits member for 3 years
seen 16 hours ago

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


1d
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?
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...