Forum Replies Created

Viewing 15 posts - 1 through 15 (of 21 total)

  • RE: Confusion backing up DB

    Thanks for the responses. Here is further information.

    Yes, it is a backup device created in EM - but the "device" is actually a file on a remote drive, thus...

  • RE: Confusion backing up DB

    4.5 GB

    BACKUP DATABASE [Dorian_Security] TO [Dorian_Security Full backup] WITH  INIT ,  NOUNLOAD ,  NAME = N'Dorian_Security full backup',  NOSKIP ,  STATS = 10,  NOFORMAT

  • RE: Changing sa password

    Thanks!

  • RE: Backing up 50GB Dorian DB

    Thanks. Yes, I created a backup device and am archiving multiple backup images in the file. I have plenty of disk space available on the SAN. Good guess though.

  • RE: SQLAgent mail not working

    We do not want to install Outlook because of security concerns. From what I read, this issue was supposed to have been resolved with previous service packs, though we are...

  • RE: sp_attach_db without log files

    I've completed the procedure down to where it says to run DBCC CHECKDB at which point I get some errors back. If I try to run it with any of...

  • RE: sp_attach_db without log files

    OK, it's not an article, just a post - I found it.

    Create new database with same name, stop SQL Server, replace the MDF file from original database file...

  • RE: sp_attach_db without log files

    Where is the article? - I don't see it

  • RE: sp_attach_db without log files

    Thanks.

    Got the following result:

    Server: Msg 2520, Level 16, State 4, Line 1

    Could not find database 'Dorian Event Archiver'. Check sysdatabases.

    DBCC execution completed. If DBCC printed error messages, contact your system...

  • RE: sp_attach_db without log files

    I have a similar situation. I have a database data file named Dorian Event Archiver_Data.mdf and no corresponding log file. (it was deleted, no backup) I am trying to reattach...

  • RE: Creating non-local backup device

    Or maybe the better question is: How do I find out to what account do I give share permissions?

  • RE: Creating non-local backup device

    OK, thanks. To what account do I give share permissions?

    -Al

  • RE: broken/lost connection

    I got it working somehow - don't ask me. I rebooted again and it came up. Microsoft.

  • RE: broken/lost connection

    Can't get to the properties dialog... get the message 'this server connection has been unexpectedly broken and cannot be reconnected'. Cannot restart the instance.

  • RE: broken/lost connection

    It's actually just a secondary partition on the same physical drive. But the issue is that the instance won't restart for me to do anything with it.

Viewing 15 posts - 1 through 15 (of 21 total)