Questions tagged [msdb]
A system database in Microsoft SQL Server. Most commonly referenced with regard to backup history, SQL Server Agent configuration, Log Shipping, and other instance-level configuration.
45
questions
4
votes
1
answer
141
views
MSG 14262: The specified @server_name ('<server_name>') does not exist
We have an SQL Server 2019 instance (let's call it 'sample_instance') with server collation of Turkish_CI_AS. When I try to create a job, SSMS creates the part of the script that adds the target ...
-3
votes
1
answer
86
views
Restore of MSDB fails with different version error but the versions are the same [closed]
Trying to restore MSDB to a replacement server and getting this message:
Msg 3168, Level 16, State 1, Line 4
The backup of the system database on the device e:\sqlbackup\2024-02-27_msdb_DEV.bak ...
1
vote
2
answers
91
views
last backup - how many backup files and where they are?
I am restoring a database, this database is very big and it has 6 backup files (meaning the backup is split into 6 smaller files)
I can see an indication of that using the restore labelonly
...
0
votes
0
answers
761
views
Transaction aborted when accessing versioned row in table 'dbo.sysmail_profile' in database 'msdb'
I'm having some problens with SQL Database mail, basicaly anything that I try to do gives me an error like this one below:
Transaction aborted when accessing versioned row in table 'dbo....
2
votes
1
answer
188
views
How to trim the log file that stores information about job history execution?
I was having a look at my sql server jobs and proxies on an specific server in the production environment.
I pretty much have an script to check the status of the jobs but in case I have to ...
0
votes
1
answer
122
views
Recovery_model for backupset table null sqlserver
Going through https://www.sqlshack.com/understanding-database-recovery-models/
I see that there are three types of recovery models:
SIMPLE
FULL
BULK_Logged
But for the table msdb.dbo.backupset I can ...
2
votes
1
answer
404
views
Effect on msdb transaction log of running sp_delete_backuphistory for first time?
Have a server with regular db backups but strangely sp_delete_backuphistory has never been scheduled so msdb is bigger than expected. Backup history goes back 5 years in that table but only needs ...
1
vote
1
answer
769
views
sp_delete_backuphistory not working
I am using sql Server 2008 R2.
We are using below query for reducing the msdb size.
use msdb exec sp_delete_backuphistory '01-MAR-2020'
When i execute this query in server whose msdb size is 15GB ...
0
votes
1
answer
53
views
Analyst MSDB Access SQL Server 2017
i'm an accidental DBA for a company and having trouble figuring out this permissions situation.
We have a new 2017 SQL server that I would like to get our report writer / analysts access to a few of ...
2
votes
1
answer
341
views
SQL Server Installer appears to be resetting MSDB Recovery Mode to Simple
Everytime we upgrade a SQL Server installation (service pack or cumulative update), msdb is changed from FULL recovery mode to SIMPLE recovery mode.
I understand that the msdb database doesn't change ...
1
vote
1
answer
301
views
Why MSDB transaction log file grew while MSDB was in Simple recovery mode?
I have Availability Group of 3 servers, and transaction log backups for databases in Availability Group are taken on a secondary replica, each 1 minute
It was working like this for several months
...
-2
votes
2
answers
1k
views
remove a step from sql agent jobs
I copied a bunch of jobs from an HA server to a regular server and I need to delete only the first step( checks for the primary) on these jobs not all jobs. Any suggestion?
this is the query I used to ...
1
vote
1
answer
4k
views
Is it safe to stop the shrinking of MSDB?
In a production server (Microsoft SQL Server 2014), the file MSDBData.mdf ballooned up to more than 450 GB, eating almost all the space in the server (only 38 GB remaining).
First thing, I created ...
0
votes
1
answer
204
views
upgrade MSDB only?
good morning.
we currently are running on SQL server 2008 r2 and going to Sql server 2016. we are told we cannot do an in place upgrade and will have to restore all SSIS and jobs manually (script, ...
2
votes
1
answer
1k
views
What is the best practice for the msdb database owner?
In the course of reading up on SQL Server security best practices, I learned that databases should generally be owned by a dedicated, low-privileged login (sometimes a separate one for each DB or each ...