Comments
Sort by recent activity
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...
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
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...
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...
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...
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.
Thank you this is a great suggestion! I will try this. / comments
Thank you this is a great suggestion! I will try this.
Hello Aaron,
I would also like this feature. As part of our production deployment process I would like to be able to confirm via a SQL statement that there are no-invalid objects in *ANY* of the production user databases. If there was an output which confirmed the results that we could keep for SOC purposes (i.e. Database Name checked and the results) that would be very helpful. Right now i have to do each data base one at a time and take a screen print for the documentation and this is time consuming.
Thank you! / comments
Hello Aaron,
I would also like this feature. As part of our production deployment process I would like to be able to confirm via a SQL statement that there are no-invalid objects in *ANY* of the p...