Forum Replies Created

Viewing 15 posts - 1,096 through 1,110 (of 1,319 total)

  • RE: Shrinking almost empty datafile not possible

    Can you do something like this? I'm assuming you would know if "It was determined that a transaction log backup had run at the same time that the shrink was...

    -- You can't be late until you show up.

  • RE: Transaction is taking more space after shrinking also

    I'd do exactly as Cath has suggested but just from your description of the problem (grows to 20GB over the weekend), I can tell you are not backing up the...

    -- You can't be late until you show up.

  • RE: Export to CSV text files

    Yes, if you save it, it becomes a DTS package. You can then open the package to add additional events (emails for instance). Simply save from the import/export wizard and...

    -- You can't be late until you show up.

  • RE: backup details?????

    Based on the OP's comments, he/she did not want to "read" anymore about how to accomplish the task at hand, therefore didn't want anybody posting links to valuable information. I...

    -- You can't be late until you show up.

  • RE: backup details?????

    love (6/2/2008)


    plz help me for full details ,, i dunot need any link ...

    help me out...

    Thanks MohammedU 😀 Some posters want everything given to them without any effort on their...

    -- You can't be late until you show up.

  • RE: MSFTE

    Sorry, didn't catch that it was for SQL2K. Anyway, this site has a couple of articles (parts 1 and 2!) that should help:

    http://www.sitepoint.com/blogs/2006/11/12/sql-server-full-text-search-protips-part-1-setup/

    -- You can't be late until you show up.

  • RE: Is it possible to add one more System Database(5th)?

    When creating a database, there is no way that I'm aware of that you can specify a database "type". An interview question? Did you get the job, or more importantly,...

    -- You can't be late until you show up.

  • RE: MSFTE

    Check out:

    http://www.eggheadcafe.com/articles/20010422.asp

    http://msdn.microsoft.com/en-us/library/ms345119.aspx

    A wealth of information on Google!

    -- You can't be late until you show up.

  • RE: SQL Server 2005 Backup Fails

    This may be totally off-base but, can you backup with init as opposed to append?

    -- You can't be late until you show up.

  • RE: SQL Server 2005 Backup Fails

    In the link it said to "delete" the full text catalog. If that doesn't work, I don't know what else to try besides a call to PSS. Not much else...

    -- You can't be late until you show up.

  • RE: Database Missing

    Brandie Tarvin (5/30/2008)


    Do you actually have permissions to see ALL the databases on the servers? It could be, if you're not using a SysAdmin account, that you just can't...

    -- You can't be late until you show up.

  • RE: SQL Server Questions

    Depends on how you want to do it. You can export/import the entire data set or build a SQL script to insert only those rows that don't exist in the...

    -- You can't be late until you show up.

  • RE: Backup a SQL database from one domain to another

    As long as you get backups, whatever works for you is fine. Be sure to test the validity of your backup files from time to time.

    -- You can't be late until you show up.

  • RE: database maintainance

    Whatever account starts your SQL Services seems to have had some type of permissions change. If you're not the network admin, get hold of him or her and have them...

    -- You can't be late until you show up.

  • RE: Backup a SQL database from one domain to another

    The user must be a valid domain user on the domain attaching to AND have, at minimum, rights to read to perform net use to \\Servername\SQLDataShare\Backups\Full\ . It'll also need...

    -- You can't be late until you show up.

Viewing 15 posts - 1,096 through 1,110 (of 1,319 total)