All Questions
Tagged with datafile filegroups
4 questions with no upvoted or accepted answers
2
votes
0
answers
449
views
SQL Server 2008 R2 - Two Files Stuck In Restoring Status
Background: SQL Server 2008 R2 mirrored and clustered.
We recently failed over the databases via mirror and everything went smoothly. When it was time to do a differential backup, I got an error so I ...
- 91
1
vote
0
answers
132
views
Transactional Replication and distribution database size
I have a transactional replication set up with initialize from backup.
In the secondary database server,i have a drive(d:) for data files alone.
I have noticed that this drive is getting filled and i ...
- 1,335
0
votes
0
answers
491
views
SQL Server File or Filegroup Creation Date
Is there a way to find out when a File was added to a filegroup in SQL Server. Or how to determine when a filegroup was created?
I've tried querying the sys tables looking at the lsn information and ...
0
votes
1
answer
116
views
Database still reports 600GB after removing 500GB File
I have a database with three files
Log
Primary Data File
Blob Data file
the database was becoming too big to manage (600GB) so we removed the blob data (500GB) into FileStorage outside the DB.
we ...
- 121