Forum Replies Created

Viewing 15 posts - 511 through 525 (of 966 total)

  • RE: SSMS not opening

    Is SQL running on the same machine that SSMS is installed on?

    What are you typing in the Server Name field when trying to connect?

  • RE: Tlog backup task failed particular time period?

    I would say it depends on how long your full backup takes. If it takes 20 minutes to do a full moving the full backup to 1215 will just cause...

  • RE: SSMS not opening

    SSMS fails to open, or it fails to connect to a database function, like Database Engine, Reporting Services, etc? I ask because these are two very different things.

    If it opens...

  • RE: If Distribution database gets keep on growing, what is the reason? Replication health is good

    What has it grown to so far? What is the size of the log file for the distribution database? What recovery model is the distribution database set to? If it...

  • RE: Tlog backup task failed particular time period?

    You have another process going on at the same time that has a lock on a resource that is deadlocking with your log backups and SQL deemed it was easier...

  • RE: SQL server Agent has failed

    Are you using a service account or a local system account like Local System or Network Service? How did you set the credentials for the SQL Server Service? Through the...

  • RE: Log shipping a distribution server

    I thought one of Paul Randal's SQL Q&As for TechNet magazine back in the day had something on what technologies could be mixed with the different databases used in replication....

  • RE: How to migrate sql scripts from 08 to 05

    How many scripts are you talking about? If it is not too many you can open up the scripts in Management Studio, connect to the SQL 2005 instance and start...

  • RE: Maintenance Plan issue

    You can also run the following:

    EXEC sp_helpdb 'TempDB'

    And check that the path that it shows the tempdb_log file is at is there and the file is there. If the path...

  • RE: Modeling relational databases

    I have not used it but did see a short demo of ERStudio from Embarcadero when looking for tools for a migration project. It could do what I needed at...

  • RE: editting data in an encrypted column

    I'm attempting (unsuccessfully) to reset a password, the issue is that the column with the passwords in is encrypted. I don't know what key was used to encrypt the data...

  • RE: Suspending Database Mirroring

    I do not believe so.

    Automatic failover requires the following conditions:

    The database mirroring session must be running in high-safety mode and must possess a witness. For more information, see Synchronous...

  • RE: Is database mirroring used much in the industry?

    I know that we use it in our environment for a HA scenario, but cannot speak for an industry as a whole. If you are looking at upgrading soon you...

  • RE: Login Auditing

    Which question exactly was not answered?

    Where are login audits stored?

    SQL Error log, if you configure auditing successful/failed logins through the instance properties. This is the same for every version of...

  • RE: tools to track disk or folder used space

    Couldn't monitoring tools such as SCOM accomplish what you are trying to do?

Viewing 15 posts - 511 through 525 (of 966 total)