Forum Replies Created

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

  • RE: Restoring database by specifying network path for a local pc

    Hi

    Shares have permission specific problems/errors. Have you tried using the fully qualified server name directory instead? assuming you already rights on the machine/disks...

  • RE: Managing Registered Servers

    Oh well.

    If i was in your shoes...i would use a technology called: mRemoteG, its free-ware which contains a XML editable file on your local OS.

    Sorry could not be of more...

  • RE: Managing Registered Servers

    Step 1 DON'T CHANGE SERVER IP's.

    Its just bad practice and should never happen.

    I bet that should solve this issue?

  • RE: Planning Disk and File layout

    First question to ask yourself during data warehousing (talking from my own experience here)...

    How strong is your server? Then, look at your disk speeds and set-up of your disk array.

    remember...

  • RE: SQL server restart

    checks you event viewer for system updates

  • RE: SQL Server 2008 R2 , change domain

    Hey, speak to the system admins, to add an alias on the DNS pointing to the new server.

  • RE: Probably a very dumb file size question...

    well, as long as you have disk, you can pre-grow you file to any desired size. Think of it as a book. You can allocate unused pages, but data will...

  • RE: Linked server issue

    have you checked the firewall?

  • RE: SQL Server Replication

    Hi

    a simple GUI will be the Replication monitor, it displays from start to finish.

  • RE: Online Indexing Being Blocked

    Hey, what type of indexing are you doing?

    can you tell me a little more?

  • RE: Tempdb

    so what you telling me is that due to contention my set up should be as follows...

    6 CPU machine and 6 LUNS allocated for mdfs.

    I can reduce the size of...

  • RE: Tempdb

    so why is the best practice to have multiple mdf's and keep a constant ldf if the log is the one with processing in it? Sorry for the questions but...

  • RE: Tempdb

    yes, temp tables which also makes use of Unions... which is fine. (that will use up tempdb space but on the mdf only if i am right?)

    Now any idea why...

  • RE: Tempdb

    cool, from how i understand it is.........

    tempdb works a little different as opposed to normal db's, the mdf is used in processing of query's, hash tables, union joins etc.

    the ldf...

  • RE: Tempdb

    100% but that's not what i am asking, my question is what is it used for.

    file type specific.

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