• did you hit the refresh button in SSMS ?
• can you see the job active in SQLAgent

  

...

Check: https://www.sqlservercentral.com/articles/using-database-master-keys-in-sql-server

I haven't tested SSB with AGs myself. #blush# ( because we do not use it in that way )

because the log backup actually resets marks the log to be overwritten.

Preceding a full backup, you are sure that the next log backup will no longer contain encrypted log data.

only TCP/IP active ? ( Check SQL Server 20** Configuration Manager / Network Configuration )

we actually need your full bcp command to figure out what's going on.

REM Create_FMT_files
bcp "[yourdb].[yourschema].[yourtableorview]" format NUL -fD:\BCP\BCPExp\yourdb_yourschema_yourtableorview.fmt -S yoursqlserver -U sqluser-P sqlpwd -n  -o D:\BCP\BCPExp\yourdb_yourschema_yourtableorview_fmt.log...

• This reply was modified 4 years, 6 months ago by Johan Bijnens.
• This reply was modified 4 years, 6 months ago by Johan Bijnens.

yes, you can.

ALTER DATABASE [master] SET COMPATIBILITY_LEVEL = 130

Do you have proprietary objects deployed in master db ?

if yes, can you check they are still working as...

• they tie together, right

• /* https://docs.microsoft.com/en-us/sql/relational-databases/partitions/create-partitioned-tables-and-indexes */
  -- Creates a partition function called myRangePF1 that will partition a table into four partitions  
  CREATE PARTITION FUNCTION myRangePF1...

Even opletten :

prv.value is a boundary value, left or right according to your partitioning definition.

It is the tipping point to put data in the next partition. ( in case of...

-- http://www.davidemauri.it/DasBlog/CategoryView,category,Sql%20Server%202005.aspx
--create schema ALZDBA


/* Welke query(s) uitvoeren ? */
Declare @WelkeQuery int


/* 0 = alles , (1,2,3,4,5) is enkel die query */
set @WelkeQuery = 4

if @WelkeQuery in (...

You could use a scheduled task to run this Powershell script

( save it as e.g. C:\Powershell\SQLServer_Backup_Full.ps1 )

<#
Create sqlserver backup for all databases of the local default instance

Johan...

Check todays featured atricle "Monitor SQL Server Error Logs with PowerShell" to get you started

do not drink e.g. orange juice as it is very sour and sweet which is bad for your voice.

Database Mirroring in SQL Server 2008

SQL Server 2008 R2 Database Mirroring with Automatic Failover Across the Internet

It may be a bit late to start it all in 2021...

All nice and well,

How about:

declare @Data table (begin_time varchar(8), 
                 ...

• This reply was modified 4 years, 7 months ago by Johan Bijnens.

You are moving multiple files to the same...