Forum Replies Created

Viewing 15 posts - 1,966 through 1,980 (of 2,904 total)

  • RE: Corrupted DB Help Needed

    You say you got it to work. Great news.

    However, what enabled you to solve the issue? Was it one of our suggestions? Or one of your own?

    Post the solution here...

  • RE: Reading Image Data

    Please post your question in an appropriate forum.

    This forum "Question of the Day" is specifically for comments on the Question of the Day (QOD). The QOD is a test question...

  • RE: Third party tools, who uses them?

    Just don't do it! Unless you really have to.

    Nothing works better for backup and recovery than using the SQL Server commands.

    I backup my databases to hard drive and then use...

  • RE: Restoring SQL Server without having the Data files?

    Also, as I said search the articles on this site for information on restoring the Master database.

    -SQLBill

  • RE: Windows Authentication mode (How NT rights are mapped?)

    When you use Antares' method (via Enterprise Manager) on the General tab there is the option for making the login use SQL Server Authentication or Windows Authentication. You will want...

  • RE: Restoring SQL Server without having the Data files?

    Another possibility....did your Veritas backup of the operating system backup ALL the files? If so, then the files the maintenance plan created when it did the backups should have been...

  • RE: cant connect to named instance

    What happens if you connect using just 111.22.33.44?

    I have two instances on my server. I set my ODBC connection to the IP only (no instance). Permissions on SQL Server do...

  • RE: Shrink Database

    Try this:

    1. In Enterprise Manager, find the database. Right click on it and select Properties. Go to the Data Tab and find the name of the data file. Do the...

  • RE: Message box is too small

    What's wrong with the size of the message box?

    If you mean that it only displays one line, you might want to check your browser version. There was a problem...

  • RE: Database Restore stuck in "loading" state.

    It sounds like Veritas MIGHT have been trying to VERIFY the final results. See if there is an option to just do the restore without data checks (verify, whatever).

    I backup...

  • RE: I ask of those who know.....

    Permissions. The services (SQLServerAgent and MSSQLServer) all run under either the local admin or domain admin account. Will that account change with the change of the domain? Probably.

    IP Address. Will...

  • RE: Restoring SQL Server without having the Data files?

    Let me see if I have this correct...

    You have a SQL Server up and running. You used Veritas to backup the Operating System and SQL Server maint plan to backup...

  • RE: Testing for existance of a table

    Here's one way:

    IF EXISTS

      (SELECT Name

       FROM <dbname>..SysObjects

       WHERE Name = '<tablename>')

    <rest of code>

    Replace <dbname> with the name of the database the table should be in.

    Replace <tablename> with the...

  • RE: Connection Error

    Network documentation just means any documentation that your network admin may have created.

    Has the SA password been changed?

    Has the password for the SQLServerAgent service changed? Is the account a domain...

  • RE: Restoring SQL Server without having the Data files?

    With Veritas, the Open File Option won't work with SQL Server .mdf and .ldf files. You need the Agent for SQL Server.

    What exactly are you trying to do? What happened?

    Are...

Viewing 15 posts - 1,966 through 1,980 (of 2,904 total)