[MS SQL Server] Error while taking the backup |
- Error while taking the backup
- Logical Backup Maintenance Plan
- DTA
- Cancelling a Bulk Operation impact
- Performance counters missing...
- Can some one help to fix this code?
| Posted: 05 Sep 2013 12:57 AM PDT Hi Allhere we are trying to take a backup using job but we are getting error message we are trying to get the details from view history, and even viewer and we tried to take the backup manually also we are getting below error. Cannot open backup device 'D:\Backup\ION_DB_UAT_03\ION_DB_UAT_03_backup_05_Sep_2013_06_46_09.bak'. Operating system error 5(Access is denied.). [SQLSTATE 42000] (Error 3201) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.please advise me on this. |
| Logical Backup Maintenance Plan Posted: 04 Sep 2013 09:19 AM PDT I have full backup jobs that run nightly. I would like to create a maintenance plan to run a 'logical' backup weekly. Can someone point out any scripts for this? I know I can R-Click in Object Explorer and generate scripts for this, but once placed in a stored procedure, it would be a static script. I need a dynamic script to capture new tables. |
| Posted: 04 Sep 2013 10:26 PM PDT I uploaded a trace file to DTA, the file size is 4GB & i need to run it against all Databases.What will happen if i stop it with recommendations in between??or should i wait for the completion?? please suggest |
| Cancelling a Bulk Operation impact Posted: 04 Sep 2013 11:45 PM PDT Hi Experts,What happens if i cancel a bulk insert operation for 1 Billions rows into a table in between?is the effect same for queries using command BCP , BULK INSERT and INSERT INTO?TIA |
| Performance counters missing... Posted: 04 Sep 2013 10:35 PM PDT Hi Team , SQL Server performance database objects---------------------------------------These SQL Server performance objects are not available: ''SQLServer:Cache Manager'' The SQL Server is not configured for ''SQL PerfMon Integration''.Reconfigure SQL Server for ''SQL PerfMon Integration'', and restartSQL Server.Thansk Lavanya |
| Can some one help to fix this code? Posted: 04 Sep 2013 06:50 AM PDT Hello trying to create this code:CREATE TRIGGER [dbo].[Check_For_Term] ON [dbo].[HRIS_Employee_Archive] FOR INSERTASInsert Into HRIS_Term_Employee(Last_Name, First_Name , M_Name , Emp_ID , Business_Unit , Job_Title , Supervisor_ID, Supervisor_Last_Name , Supervisor_First_Name , Floor,DT)Select ne.Last_Name, ne.First_Name, ne.M_Name,ne.Emp_ID, ne.Home_Bu+' - '+fin.BUNAME as 'Business Unit',j.Job_Title,ne.Supervisor_ID, case When nes.Last_Name is null then 'N/A' else nes.Last_Name end AS 'S_Last_Name',case When nes.First_Name is null then 'N/A' else nes.First_Name end AS 'S_First_Name',ne.Floor,ne.DTfrom DBO.HRIS_Employee_Archive ne,dbo.HRIS_JobTitle j,CRS_Financial.dbo.BUDEPT fin,dbo.HRIS_Employee nesWhere ne.Job_ID=j.Job_IDANDne.Home_Bu=fin.BUand ne.Supervisor_ID*=nes.Emp_IDAND ne.Log_Type='New'AND ne.DT is not NullAND ne.Emp_ID in (Select Emp_ID from DBO.HRIS_Employee_Archive Where Log_Type='OLD' AND DT Is Null)AND ne.EMP_ID not in (select Emp_ID from HRIS_Term_Employee)GOCREATE TRIGGER [dbo].[Delete_Non_Term] ON [dbo].[HRIS_Employee_Archive] FOR INSERTAScreate table #Temp (EMP_ID int)Insert into #Temp (EMP_ID)Select ne.EMP_IDfrom DBO.HRIS_Employee_Archive ne,dbo.HRIS_JobTitle j,CRS_Financial.dbo.BUDEPT fin,dbo.HRIS_Employee nesWhere ne.Job_ID=j.Job_IDANDne.Home_Bu=fin.BUand ne.Supervisor_ID*=nes.Emp_IDAND ne.Log_Type='OLD'AND ne.DT is not NullAND ne.Emp_ID in (Select Emp_ID from DBO.HRIS_Employee_Archive Where Log_Type='NEW' AND DT Is Null)AND ne.EMP_ID in (select Emp_ID from HRIS_Term_Employee)delete from HRIS_Term_Employeewhere HRIS_Term_Employee.EMP_ID in (Select EMP_ID from #TEMP)GOI get this error:Msg 4147, Level 15, State 1, Line 17The query uses non-ANSI outer join operators ("*=" or "=*"). To run this query without modification, please set the compatibility level for current database to 80, using the SET COMPATIBILITY_LEVEL option of ALTER DATABASE. It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN). In the future versions of SQL Server, non-ANSI join operators will not be supported even in backward-compatibility modes.Msg 156, Level 15, State 1, Line 20Incorrect syntax near the keyword 'AND'.Msg 4147, Level 15, State 1, Procedure Delete_Non_Term, Line 17The query uses non-ANSI outer join operators ("*=" or "=*"). To run this query without modification, please set the compatibility level for current database to 80, using the SET COMPATIBILITY_LEVEL option of ALTER DATABASE. It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN). In the future versions of SQL Server, non-ANSI join operators will not be supported even in backward-compatibility modes.Msg 156, Level 15, State 1, Procedure Delete_Non_Term, Line 20Incorrect syntax near the keyword 'AND'. |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment