Skip to main content

All Questions

Filter by
Sorted by
Tagged with
-2 votes
1 answer
40 views

How to modify filepath of a database file that is inside a file group [duplicate]

How do you modify filepath of a database file that is inside a filegroup? Just the normal and direct way? Alter database [] Modify file (name='', newfilepath='') Or Alter database [] Modify filegroup ...
Michelle Urbano's user avatar
0 votes
0 answers
345 views

How to open .bin SQL database?

I'm stuck and not sure if somebody had a similar issue. I have an old database stored as .bin files. It dates back to 2012. I can see an xml catalogue file which indicates to me that it is some kind ...
Ali Nato's user avatar
5 votes
1 answer
989 views

Find what data is placed in a datafile

I have a database with 5 .ndf (secondary) datafiles on SQL Server 2008 R2. (Each of these datafiles is assigned to a separate filegroup.) I want to know what data is there in those files. Is it ...
Stackoverflowuser's user avatar