Forum Replies Created

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

  • RE: Error on completion of backup job

    Yes and i get the same response. Have narrowed it down to one database now.

    Any ideas? Thanks for the response.

  • RE: SQL-2005 Installation on an existing SQL-2000 server

    Certainly this can be done and it not that hard. There ar e the obligitory pre-reqs and you should read MS articles on the subject:

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

    One of the main...

  • RE: general question about DB space

    A stupid question really. Especially given MS's liking for disk-hungry apps.

  • RE: How do you move master db??

    http://support.microsoft.com/kb/224071

    Take backups first.

  • RE: limit db size

    Alvin Ramard (11/17/2008)


    Is there more "stuff" save to Sharepoint than should be? Are there multiple copies that could be delete? Can anything be archived or deleted,...

  • RE: limit db size

    I'm not a DBA so I'm not sure of everything quite yet. I picked up the work when are full time db left for vacation and never returned.

    I really do...

  • RE: limit db size

    My bubble has been burst !

    What that there is something that Gail doesnt know? Yeah im surprised to. My confidence is shaken but my hero-worship is far to strong. Gail...

  • RE: limit db size

    Mike (11/13/2008)


    Is there anyway to control the size of it? Its just growing and growing and growing and eating up my server space.

    Is like a worm that just...

  • RE: Torn page detection

    GilaMonster (11/13/2008)


    Every database should have this on in SQL 2000. In 2005 it's been replaced by page checksums which should be used instead.

    It's a way for SQL to detect that...

  • RE: MSSQL 2000 and 2005 COEXIST on CLUSTER??

    This shouldnt be a problem for you. SQL 2005 clusters very easily. Like MarkusB said, make sure you have second failover group and the virtual-instance name is different and you...

  • RE: How do I set up scripts to run daily?

    nwinningham (11/13/2008)


    I am trying to run sql scripts from SSIS.

    Is this to be a scheduled repeatable job? If so the simplest way is to use the ssms to create a...

  • RE: SQL Server 2005 and Windows 2003 Active Directory

    It could be differences in the paths stored within excel to object within AD where AD structure differs from Novell.

    Though to be honest I'm just t aking a wild stab....

  • RE: database attach/detach

    When attaching the db in the new server you will just need to specify (re-locate) the individual files (mdf and ldf).

    Should be fine after that. 🙂

  • RE: How to shut down a SQL 2005 Failover Cluster ?

    I have seen it before that when doing an operation like this (using method 2), once the services are down, they dont easily come up. Suggest method 1!

  • RE: Monitoring DBs

    rbarryyoung (11/12/2008)


    Steve Jones - Editor (11/12/2008)

    Heh, all things considered, I would rather not have my low-end monitored.

    😀

    Crude'ness :rolleyes:

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