Guest User

Untitled

a guest
Dec 15th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.05 KB | None | 0 0
  1. 1> USE mssqlsystemresource
  2. 2> GO
  3. Changed database context to 'mssqlsystemresource'.
  4. 1> SELECT type, type_desc, physical_name FROM sys.database_files;
  5. 2> GO
  6. type type_desc physical_name
  7. ---- ------------------------------------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  8. 0 ROWS d:dbsshs17o1116_092427_2cmd43objx64retailsqlmkmastrdatabasesmkmastr.projmssqlsystemresource.mdf
  9. 1 LOG d:dbsshs17o1116_092427_2cmd43objx64retailsqlmkmastrdatabasesmkmastr.projmssqlsystemresource.ldf
  10.  
  11. (2 rows affected)
  12.  
  13. 1> SELECT LEFT(name,20), LEFT(physical_name,35) FROM sys.master_files WHERE name LIKE 'ms%';
  14. 2> GO
  15.  
  16. -------------------- -----------------------------------
  17. MSDBData /var/opt/mssql/data/MSDBData.mdf
  18. MSDBLog /var/opt/mssql/data/MSDBLog.ldf
  19. (2 rows affected)
  20.  
  21. spid9s Starting up database 'mssqlsystemresource'.
  22. spid9s The resource database build version is 14.00.3008. This is an informational message only. No user action is required.
  23.  
  24. /opt/mssql/lib/sqlservr/Content/binn/mssqlsystemresource.mdf
  25.  
  26. d:dbsshs17o1116_092427_2cmd43objx64retailsqlmkmastrdatabasesmkmastr.projmssqlsystemresource.mdf
Add Comment
Please, Sign In to add comment