Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [master-system-database]

The SQL Server master system database

32 questions
14
votes
3 answers

Master database is corrupt, instance won't start - what are my options?

Help! My master database is corrupt, I can't even bring the SQL instance online! What are my options to get my server back up? I do have a backup of master, but the MSDN page "Restoring the master Database" asks me to start the instance in…
BradC
  • 10,073
  • 9
  • 51
  • 89
12
votes
3 answers

Why use master to create a database?

I have a short question, why do I use use master; to create a database? Here is the example from the Microsoft documentation USE master ; GO CREATE DATABASE Sales ON ( NAME = Sales_dat, FILENAME = 'C:\Program Files\...\saledat.mdf', SIZE =…
S Nell
  • 123
  • 1
  • 1
  • 5
7
votes
2 answers

How can I restore a master database from its bak file?

During a penetration test I found multiple .bak-files for an MSSQL database. I want to restore them all. In a Windows VM I installed SQL Server 2017. For restoring the master database, I put the server in single-user mode and tried restoring the…
Beurtschipper
  • 173
  • 1
  • 4
5
votes
2 answers

Downsides of switching Master to Simple recovery?

I've read a lot about this over the last couple of days, but none specifically on the Master db. If I switch from full to simple, will it flush out any plans, statistics, etc? Any performance hits? I know how to proceed, just never seen Master on…
user80151
  • 209
  • 1
  • 5
4
votes
1 answer

Database Properties Error - sys.spt_values missing but dbo.spt_values works?

We have SQL2012 SP1 installed on several servers and have run into an issue on one instance trying to view the database properties in SSMS. (This happens with both SSMS 11.0.5058.0 and 11.0.3128.0.) I have crawled all over Google results looking for…
Vinnie
  • 175
  • 1
  • 5
4
votes
1 answer

Is it normal to constantly have 30+ connections to ‘master’ database in MS SQL Server 2012?

In troubleshooting why I was seeing so many connections to one of our internally used databases in SQL Server 2012. A query I found online that had been helpful to me was this: SELECT DB_NAME(sP.dbid) AS the_database , COUNT(sP.spid) AS…
Rob V
  • 375
  • 2
  • 4
  • 8
3
votes
2 answers

I'm having trouble copying database users from one Azure SQL Server to another. The EXECUTE permission was denied

I'm trying to use the instructions here - https://learn.microsoft.com/en-US/troubleshoot/sql/database-engine/security/transfer-logins-passwords-between-instances to copy logins between the server which hosts my primary DB and the server which hosts…
Yossi Geretz
  • 349
  • 1
  • 11
3
votes
1 answer

Why does the "Date Created" for the master database show such an old date (8 April 2003) in SQL Server 2008 R2?

Why does the "Date Created" for the master database show such an old date? I created the new instance today, not 2003.
dee14
3
votes
1 answer

Duplicate tables and procedures in master database

I've just discovered, that master database contains duplicates of some other databases' tables and stored procedures. For example, I have a database SomeDB with table justTable in it. For some reason, a copy of this table is in master as well, but…
retif
  • 427
  • 1
  • 4
  • 9
2
votes
1 answer

How to find function definition

How can I find the definitions of below system functions in SQL Server: has_access permission_name I tried with DAC connection but getting below error: Msg 15009, Level 16, State 1, Procedure sp_helptext, Line 54 [Batch Start Line 118] The…
SQLPRODDBA
  • 1,928
  • 2
  • 33
  • 48
2
votes
1 answer

Where is authentication information saved in master?

When using SQL Server Authentication mode, I know that usernames and hashed passwords are saved in the master database. I wonder is there a way to retrieve that information? If yes, which tables stores it? (except contained database users) Thanks…
igelr
  • 2,162
  • 3
  • 26
  • 56
2
votes
1 answer

Snapshot isolation transaction failed in database 'Master'

We have a production database running in snapshot isolation level. The application have a functionality where the user can selected a few records and command it to be processed. A lot is done while the process run (executes SP, create temp…
jean
  • 495
  • 4
  • 15
2
votes
2 answers

Migrating master databases between clusters by detaching/attaching them

As a migration strategy is it possible or feasible to detach a master database in a Microsoft SQL Server cluster and then attaching a different master database's files from another cluster? The goal is to migrate a cluster from one server to a…
Tulains Córdova
  • 723
  • 6
  • 14
  • 28
2
votes
1 answer

Recovering credential data from a master DB backup

On a SQL Server 2008 R2 instance, a misconfigured credential used as a SSIS proxy for an SSA job was dropped before I could look at the system views to figure out when it was originally misconfigured. I restored a backup of the master DB under an…
MattyZDBA
  • 1,955
  • 3
  • 20
  • 32
1
vote
1 answer

How to restart SQL Server Instance after restore master

At work we have a productive SQL Server working, and we create backups of each database periodically, including system databases master, msdb and model. I'm trying to restore the whole datawarehouse into another SQL Server instance as a test, to…
santiago arnesano
  • 11
  • 2
1
2 3