Forum Replies Created

Viewing 15 posts - 76 through 90 (of 1,154 total)

  • RE: Backup failure

    Sushant Yadav (4/2/2014)

    no that dll is not present on

    C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\SQLDTSSS90.DLL

    location

    I found that on following location

    C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLDTSSS90.DLL

    Backup MSDB database.

    Run this and restart...

    April 3, 2014 at 8:18 am

    #1702876

  • RE: DTEXEC returning Exit Code 5

    Scott Nicholson-254313 (4/1/2014)

    1. This package is on-demand execution triggered from an application. Setting it as a job won't work.

    2. I am sysadmin on the server. The...

    April 1, 2014 at 5:51 pm

    #1702293

  • RE: SQL Cluster

    lptech (4/1/2014)

    You should consider whether you want your SQL Server instance failing over without warning, possibly during normal business hours. It might be a better idea to have your monitoring...

    April 1, 2014 at 2:22 pm

    #1702218

  • RE: SQL Server 2008 R2 Activity Monitor

    Grace09 (4/1/2014)

    Many users have been experiencing slowness. I just start looking at Activity Monitor and these 2 numbers alert me.

    You should be more concerned about the current wait stats. Do...

    April 1, 2014 at 1:19 pm

    #1702203

  • RE: DTEXEC returning Exit Code 5

    Did you create a server proxy account for the non-sysadmin users to run XP_cmdshell ? Are you a sysadmin on the server and is it not possible to schedule the...

    April 1, 2014 at 1:17 pm

    #1702199

  • RE: SQL Cluster

    Enthusiastic Jones (4/1/2014)

    I'm referring to the option in cluster manager where if the agent can't start it causes the instance to failover to another node. I'm trying to see how...

    April 1, 2014 at 11:15 am

    #1702160

  • RE: SQL Server 2008 R2 Activity Monitor

    Are you experiencing any Network or I\O performance issues ? What's the recent Wait time and top ones in the list ?

    --

    SQLBuddy

    April 1, 2014 at 10:59 am

    #1702151

  • RE: RAISERROR not showing custom message in job history

    Did you use WITH LOG ..

    RAISERROR('text', 16, 1) WITH LOG

    --

    SQLBuddy

    April 1, 2014 at 10:54 am

    #1702146

  • RE: DTEXEC returning Exit Code 5

    What's the package protection level ?

    --

    SQLBuddy

    April 1, 2014 at 10:29 am

    #1702133

  • RE: Can Package Be Run From Client Machine? Will Connect To Separate SQL Server Machine.

    It can be run. But that's not a good approach.

    Instead of having the dependencies on the client desktops, use a network drive for storing those input and output files.

    If that's...

    April 1, 2014 at 10:26 am

    #1702131

  • RE: The SQL Server service terminated

    Also check if you had any memory dump files created by SQL Server in it's log folder.

    --

    SQLBuddy

    April 1, 2014 at 10:12 am

    #1702123

  • RE: Log shipping and shrinking data file

    jesinj (2/3/2011)

    Hi

    Have a question on shrinking datafile when its log shipped.

    When the secondary database is setup in standby mode and i shrink the data file on the...

    April 1, 2014 at 10:11 am

    #1702120

  • RE: Weird problem in database backups

    Are you running the backups in parallel ?

    --

    SQLBuddy

    April 1, 2014 at 10:05 am

    #1702117

  • RE: change recovery model to bulk logged runtime

    yuvipoy (4/1/2014)

    Can we change Simple recovery model to bulk logged recovery model in runtime, and again bring back to simple mode after the deletion process is over?

    since while deleting the...

    April 1, 2014 at 9:59 am

    #1702114

  • RE: SQL Cluster

    Enthusiastic Jones (4/1/2014)

    Should it be setup so that an instance be set to failover if the SQL Server Agent fails?

    Thoughts??

    Which one are you referring to , the option in the...

    April 1, 2014 at 9:55 am

    #1702112

Viewing 15 posts - 76 through 90 (of 1,154 total)