February 13, 2018 at 9:53 am
I have couple of questions regarding Log Shipping. I have a DB on SQL Server 2008 Standard edition (Primary server), I have another server 2014 standard edition (Secondary server). We take our backups in the cloud so there is a decent amount of latency due to the wire we use to transfer the data. So I am taking the backup of the primary DB but specifying the location of secondary server since the secondary server has plenty of space but I am getting this error. I am just wondering why doesn't it work? Why I am not able to take the backup of the DB and specify a different location? Is that not possible?
BACKUP DATABASE [Test] TO DISK = N'\\1.2.3.4\BackUp\Backup\Test.bak' WITH NOFORMAT, NOINIT, NAME = N'Test-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
Msg 3241, Level 16, State 0, Line 1
The media family on device '\\1.2.3.4\BackUp\Backup\Test.bak' is incorrectly formed. SQL Server cannot process this media family.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
GO
February 13, 2018 at 1:59 pm
NewBornDBA2017 - Tuesday, February 13, 2018 9:53 AMI have couple of questions regarding Log Shipping. I have a DB on SQL Server 2008 Standard edition (Primary server), I have another server 2014 standard edition (Secondary server). We take our backups in the cloud so there is a decent amount of latency due to the wire we use to transfer the data. So I am taking the backup of the primary DB but specifying the location of secondary server since the secondary server has plenty of space but I am getting this error. I am just wondering why doesn't it work? Why I am not able to take the backup of the DB and specify a different location? Is that not possible?
BACKUP DATABASE [Test] TO DISK = N'\\1.2.3.4\BackUp\Backup\Test.bak' WITH NOFORMAT, NOINIT, NAME = N'Test-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10Msg 3241, Level 16, State 0, Line 1
The media family on device '\\1.2.3.4\BackUp\Backup\Test.bak' is incorrectly formed. SQL Server cannot process this media family.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
GO
EVERYTHING about log shipping is available to you to configure manually. Most of the log shipping setups I have done for clients over the years (a couple dozen at least) have NO COPY STEP. Backup to a share and restore from the same share. Significantly more efficient in every way, including time. I also never use the GUI and just create everything (including a single job to do all databases with a step-failure-email-notification in between each) with scripts I have.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
February 13, 2018 at 5:05 pm
Check that this backup file is valid:RESTORE VERIFYONLY FROM DISK = N'\\1.2.3.4\BackUp\Backup\Test.bak'
If it is not when backup your database in another file or use FORMAT option - https://docs.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply