Forum Replies Created

Viewing 15 posts - 46 through 60 (of 119 total)

  • RE: SQL server 2008 Build List

    Microsoft SQL Server Release Services

    ( http://blogs.msdn.com/b/sqlreleaseservices/ )

    has missed the last release of a Cumulative Update for both SQL 2008 R2 (Dec) and SQL 2008 (this month). Anyone know...

    Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS

    January 24, 2012 at 8:54 am

    #1437737

  • RE: How take backup without overwriting or Appending the old files

    robgilbie (1/12/2012)

    For example in 2008 to append the machine name, date and time to a backup file name the script would look like this:

    backup database MSDB to disk = N'c:\sql...

    Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS

    January 13, 2012 at 5:29 am

    #1433157

  • RE: How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008

    free_mascot (12/22/2011)

    You can use SSIS to transfer logins.

    I don't prefer this method because the logins are disabled, and their passwords are scrambled. The "sp_help_revlogin" method avoids those two issues.

    If that's...

    Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS

    December 23, 2011 at 5:47 am

    #1425111

  • RE: All I want for Christmas

    A deer rifle, and a generator.

    Merry Christmas to all. Remember the Reason!

    Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS

    December 23, 2011 at 5:28 am

    #1425109

  • RE: 2008 R2 SP1 install fails w/o error

    Thanks. I have tried running as SERVERNAME\Administrator, and the results are the same.

    Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS

    September 19, 2011 at 7:07 am

    #1383287

  • RE: 2008 R2 SP1 install fails w/o error

    I have extracted the SP1 setup file to a folder by running SQLServer2008R2SP1-KB2528583-x86-ENU.exe -extract. Now I can go direct to setup.exe and run it.

    I see a command window blink, then...

    Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS

    September 19, 2011 at 6:21 am

    #1383270

  • RE: 2008 R2 SP1 install fails w/o error

    OomBoom (9/19/2011)

    Hi

    I would suggest login on to the server as the local administrator. Make sure the service accounts has the correct rights. The only place I have seen this before...

    Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS

    September 19, 2011 at 5:27 am

    #1383242

  • RE: Precedence

    1) "It depends".

    2) "No", probably.

    3) ModelID was "probably" a typo.

    Both the actual table structure and the data contents were unknown. I'm fairly sure I could provide schemas and data sets,...

    Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS

    July 25, 2011 at 6:09 am

    #1357707

  • RE: Settle discussion on AWE

    ALZDBA (7/19/2011)

    This has always been my ref concerning AWE ...

    AWE Memory by Brad McGehee[/url]

    That's a nice, concise page. I have several of these bookmarked but this one is quick to...

    Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS

    July 20, 2011 at 6:36 am

    #1355532

  • RE: What is up with the "Hey Kid Classification"?

    So, does he think he's being punished instead of honored?

    Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS

    May 16, 2011 at 5:16 am

    #1324940

  • RE: The owner ({domain\user}) of job {job name} does not have server access.

    Jeffrey Williams-493691 (3/21/2011)

    This is not about the server having access, but the login matching the domain account. If the domain account is all uppercase, and the login is not...

    Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS

    March 22, 2011 at 5:35 am

    #1301804

  • RE: Tables empty, but DB Size out of control

    Craig - many thanks!

    I'll be saving and studying the info you provided.

    FWIW, the 3rd party software vendor now tells me they are familiar with this behavior.

    He asked me...

    Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS

    March 3, 2011 at 12:02 pm

    #1294214

  • RE: Tables empty, but DB Size out of control

    Craig Farrell (3/2/2011)

    Mike Hinds (3/2/2011)

    (No column name)(No column name)usedtotal

    queue_messages_846626059339836631990103199419

    sysdercv6796973484825484888

    sysdesend67969734883648856

    sysconvgroup67969733140131408

    sysobjvalues2596186

    What are they, and what can I safely do with them?

    :blink: Do you have Service Broker active on this database? Check...

    Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS

    March 3, 2011 at 5:55 am

    #1293948

  • RE: Tables empty, but DB Size out of control

    Robert klimes (3/2/2011)

    This is a log shot but try running this to see if any system objects are taking up the space. system objects do not show up on the...

    Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS

    March 2, 2011 at 1:34 pm

    #1293721

  • RE: Tables empty, but DB Size out of control

    Ninja's_RGR'us (3/2/2011)

    How big are the diffs and log (avg daily).

    Mon diff = 200 MB

    Tue diff = 4.6 GB

    Today's log backups - idling 58k, between 10 and 14 MB during business...

    Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS

    March 2, 2011 at 8:43 am

    #1293555

Viewing 15 posts - 46 through 60 (of 119 total)