Activity overview
Latest activity by WindyCityGirl
I should have also said, all other (non SQL Backup) jobs are running from start to finish - its only the SQL Backup jobs that are having this issue.
W / comments
I should have also said, all other (non SQL Backup) jobs are running from start to finish - its only the SQL Backup jobs that are having this issue.
W
Thank you for your reply.
I have tried all of the suggestions from the link you provided, without success. What does seem to work if I add the database user name parameter in the job as follows. @database_name=N'master', @database_user_name=N'dbo', @flags=0 @ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
I must be missing something -
W / comments
Thank you for your reply.
I have tried all of the suggestions from the link you provided, without success. What does seem to work if I add the database user name parameter in the job as follows.@d...
Upgrade to 2016 SP 1 - Restores don't work anymore
Hello
We have upgraded to SQL Server 2016 SP 1 and SQL Backup version 8
when we run the restores, they fail with the following message.
Executed as user: XXXXX SQL Backup failed with exit code: 89...
Unable to Restore ndf to different drive letter
Hello,
I have 1 Server with two SQL Server Instances installed. I am trying to restore the same SQL backup to each instance. The backup comes from a different server (production). The database...
Thank you this is a great suggestion! I will try this. / comments
Thank you this is a great suggestion! I will try this.
Peter,
The issue with the NDF files was the "LOGICAL NAME". They needed the word FILE in front of the names I gave them. Little did I know that SQL would name the logical files something other than the file names I gave them. I found the following post on SQL SERVER Central which helped me figure this out. http://www.sqlservercentral.com/Forums/ ... 391-1.aspx
SELECT DB_NAME(database_id) AS DatabaseName, name AS LogicalFileName, physical_name AS PhysicalFileName
FROM sys.master_files AS mf
Gail Shaw
Microsoft Certified Master: SQL Server, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Thank you for all your help Peter! / comments
Peter,
The issue with the NDF files was the "LOGICAL NAME". They needed the word FILE in front of the names I gave them. Little did I know that SQL would name the logical files something other th...
Peter -
I am part way there - some of the back-ups are running. Some are not. The ones that are not are those with 1 MDF and many NDF Files. I can not get the NDF Files to restore to their correct file name they restore as the DatabaseName_1, DatabaseName_2, DatabaseName_3 if i use a scheduled job. If i do a Restore (2nd item on the toolbar) I can get it to work if i map each NDF individually Restore Option "Individual Files to specified locations" That works, but if i set up a scheduled job to do the same it does not work.
Kim / comments
Peter -
I am part way there - some of the back-ups are running. Some are not. The ones that are not are those with 1 MDF and many NDF Files. I can not get the NDF Files to restore to their corre...
NDF files not restoring to their original name
Hello,
The scenario is as follows:
I want to restore a database from the production server to the staging server
The database exists on the staging server
The drive letters and file structures ob b...
Hello Peter,
I am not sure we will be able to add cross server permissions to the production server. We do however use VisualCron which can copy the backfiles from one server to another. So we will us that to get the moved.
I have copied the backup files manually to the staging server.
I have run a restore of all the databases buy choosing restore and they run.
I still can't seem to get the jobs to run.
I have setup the SQL Backup Agent Service to use a local system account - Is that the part I am missing? Do we need an "Account" and if so what does it need? Do I need to use SQL Agent Account?
Thank you / comments
Hello Peter,
I am not sure we will be able to add cross server permissions to the production server. We do however use VisualCron which can copy the backfiles from one server to another. So we wi...
Thank you Peter - I will try that and let you know. Also do you know where the log files of what happened might be? I don't have a folder with the name found in the documentation. / comments
Thank you Peter - I will try that and let you know. Also do you know where the log files of what happened might be? I don't have a folder with the name found in the documentation.