Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 1> USE mssqlsystemresource
- 2> GO
- Changed database context to 'mssqlsystemresource'.
- 1> SELECT type, type_desc, physical_name FROM sys.database_files;
- 2> GO
- type type_desc physical_name
- ---- ------------------------------------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- 0 ROWS d:dbsshs17o1116_092427_2cmd43objx64retailsqlmkmastrdatabasesmkmastr.projmssqlsystemresource.mdf
- 1 LOG d:dbsshs17o1116_092427_2cmd43objx64retailsqlmkmastrdatabasesmkmastr.projmssqlsystemresource.ldf
- (2 rows affected)
- 1> SELECT LEFT(name,20), LEFT(physical_name,35) FROM sys.master_files WHERE name LIKE 'ms%';
- 2> GO
- -------------------- -----------------------------------
- MSDBData /var/opt/mssql/data/MSDBData.mdf
- MSDBLog /var/opt/mssql/data/MSDBLog.ldf
- (2 rows affected)
- spid9s Starting up database 'mssqlsystemresource'.
- spid9s The resource database build version is 14.00.3008. This is an informational message only. No user action is required.
- /opt/mssql/lib/sqlservr/Content/binn/mssqlsystemresource.mdf
- d:dbsshs17o1116_092427_2cmd43objx64retailsqlmkmastrdatabasesmkmastr.projmssqlsystemresource.mdf
Add Comment
Please, Sign In to add comment