The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [master-system-database]

The SQL Server master system database

Filter by
Sorted by
Tagged with
0
votes
1answer
60 views

Ola Hallengren Transaction Log Backups of System Databases

I am attempting to backup the transaction logs of master, model in addition to the msdb. MSDB transaction log backs up without any issues, but the master and model do not. Here is the script that ...
0
votes
1answer
37 views

Impact of moving the ldf and mdf files temporarily for few hours [duplicate]

I want to copy my database files(ldf and mdf) into a separate box for few hours as there is a disk space issue in my current sql server box. Currently i have mdf in one drive(:D) and ldf in another ...
6
votes
2answers
1k views

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 ...
10
votes
1answer
19k views

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 ...
2
votes
1answer
79 views

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 ...
-1
votes
3answers
213 views

Restore master database

I want to restore my master database (.dba ). I am not able to restore from PowerShell because the backup of the database is taken from a different version of the SQL Server and the PowerShell or cmd ...
12
votes
3answers
4k views

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 =...
2
votes
1answer
45 views

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 ...
0
votes
1answer
45 views

MSSQL Master db singleuser in sys.databases but multiuser in sp_helpdb

After opening SSMS, I have found that the master database on one of our production servers is in Single User mode. Result of select * from sys.databases shows, like SSMS, that the master database ...
0
votes
0answers
87 views

Expanding Cluster Drive space

I will need to expand my existing cluster drive (sql cluster with 2 node active and passive) which has sys and user database data files. My san admin told he will need to delete all the existing data ...
0
votes
3answers
601 views

Apply procedures in multiple databases

I have reach a support line that gave me a T-SQL Script for one DB that I now need to apply many more times. The original script goes like: IF EXISTS Procedure THEN DROP GO CREATE PROCEDURE [dbo]....
2
votes
1answer
585 views

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 ...
1
vote
2answers
207 views

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 ...
0
votes
1answer
156 views

My master database has multiple personnality issues

I have a tricky case for you, and I didn't find any similar issue anywhere (I must be bad at searching), so here it is... I took a backup of the master database from a production server (SQL Server ...
3
votes
1answer
1k views

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....
3
votes
1answer
453 views

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.
2
votes
1answer
61 views

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. ...
1
vote
0answers
150 views

How would I access a system view in SQL Azure master database without logging into master?

My service needs to periodically read sys.resource_stats which is only in "master" database of SQL Azure server. The service currently only accesses a "regular" database in the same server. Accessing "...
1
vote
1answer
1k views

Deny users permission to create tables in master

I have noticed that I can create tables, schemas, stored procedures etc. the master database. I don't know what is granting this permission. It's annoying, because when we open a *.sql file in SSMS, ...
4
votes
1answer
3k views

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 ...
3
votes
1answer
129 views

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,...