Forum Replies Created

Viewing 15 posts - 2,221 through 2,235 (of 2,904 total)

  • RE: OS 3rd Party Backup Tool - Why Did This Work??

    Open Backup Exec, click on Help, click on About Backup Exec. In that pop-up there will be a window that lists all your licenses. See if there is one for...

  • RE: OS 3rd Party Backup Tool - Why Did This Work??

    I use BE 8.6 also and what you experienced is a fluke according to Veritas. The only ways BE will backup a MS SQL Server database are:

    1. the database is...

  • RE: Scripting Backup, Restore and Shirink of DB

    Refer to the BOL, use the Index tab and enter BACKUP DATABASE. That will show you all the commands and how to set up 'dump devices'.

    -SQLBill

    BOL=Books OnLine=Microsoft SQL Server's Help

    Installed...

  • RE: OS 3rd Party Backup Tool - Why Did This Work??

    From your post, I'm guessing you use Veritas Backup Exec (which I also use). Do you have the Agent for SQL? (In BE, select Help>About Backup Exec and look at...

  • RE: So frustrating

    Stefan,

    I also had the problem you are experiencing. I needed to upgrade to IE 6.0 and that solved the single line and no email notification.

    -SQLBill

  • RE: Multiple User Logins??

    Hello Techie.....

    I need your help to fix an issue with an SQL Server database. The database is currently in SINGLE USER mode which only allows one connection at a time....

  • RE: How to access data from TWO (2) different SQL Server.

    Like you said....Linked Server will work. Link the two servers and then in your script use the four-part naming convention as.....

    servername.database.owner.table

     

    -SQLBill

  • RE: Points Problems

    I believe you also get points for SUBMITTING a QOD. So if I answer every DW/BI question AND submit a DW/BI QOD that is used, I will have more DW/BI...

  • RE: datalength returns different values on different databases

    Are you sure the other column is also CHAR(10)? I would expect a 0 for a VARCHAR type column and 10 for a CHAR(10) column (remember CHAR columns are padded...

  • RE: Error while registering a server

    I don't use 6.5, but....

    check that your login does have access to the database and that it uses NT login authentication.

    is your computer on a different domain than the SQL...

  • RE: Pages Expire Too Quickly

    I found the best solution to this issue is to right click on the topic and select Open in new window. When I'm done reading it/replying to it, I just...

  • RE: SQL 2k on WIN 2003

    I can't help with your question. But I can tell you that you posted in the wrong forum. This is specifically for the Question Of The Day. And that's not just...

  • RE: Can With NO_LOG option hurt recovery process?

    By the way....why does a USER have BACKUP permissions? I would NEVER give one of my users BACKUP privileges, I know how the database(s) need to be backed up to...

  • RE: Can With NO_LOG option hurt recovery process?

    Does the user run the script at the same time? If so, you could always schedule a FULL Backup to run after the script has finished. That way you will be...

  • RE: SQL optimization

    Do you really need to retrieve EVERYTHING? (SELECT *)

    If not, change the * to a list of the columns that you really need.

     

    -SQLBill

Viewing 15 posts - 2,221 through 2,235 (of 2,904 total)