Forum Replies Created

Viewing 13 posts - 76 through 88 (of 88 total)

  • RE: Shrink file odd behavior

    fhanlon (4/7/2009)

    Check if there is anything in the SQL log at the time that might help. (maybe a restore job??)

    Nope, nothing of the sort.

    So, these data files...

    April 7, 2009 at 11:58 am

    #973691

  • RE: Shrink file odd behavior

    fhanlon (4/7/2009)

    In that case is Auto Shrink turned on the database(s). I don't know if you are familiar with these options but in case you are not see

    April 7, 2009 at 10:26 am

    #973593

  • RE: Shrink file odd behavior

    steveb (4/7/2009)

    did you shirnk the database file or the log file?

    Ooops, sorry. I shrank the data file. Recovery model is simple on all of them. Daily backups...

    April 7, 2009 at 10:18 am

    #973583

  • RE: Checkdb failure

    Paul Randal (4/7/2009)

    Cool (well, kind of). Do you know if there was a failed CHECKDB beforehand?

    Nope, sure wasn't.

    This server was the report server part of a report server/sharepoint...

    April 7, 2009 at 8:56 am

    #973457

  • RE: Checkdb failure

    Reboot fixed it.

    April 7, 2009 at 8:33 am

    #973424

  • RE: Checkdb failure

    sunny Brook (4/2/2009)

    Did an online search and found Paul Randal's blog.. It suggests to check Space issue among others. Here is the link.

    http://www.sqlskills.com/BLOGS/PAUL/post/Database-snapshots-when-things-go-wrong.aspx

    I found that one too. There's 160GB...

    April 2, 2009 at 8:48 am

    #970776

  • RE: Checkdb failure

    sunny Brook (4/2/2009)

    Just a wild guess:

    is it possible that the files you are trying to access are also part of some other good DBs?

    Are you able to open...

    April 2, 2009 at 8:38 am

    #970757

  • RE: Checkdb failure

    GilaMonster (4/2/2009)

    Are you running this in a job? If so, check the SQL agent permissions.

    I was when I noticed it failed but it also fails when run from management studio.

    April 2, 2009 at 8:26 am

    #970745

  • RE: Checkdb failure

    GilaMonster (4/2/2009)

    Check the permissions on the directory D:\MSSQL.1\MSSQL\Data\ and make sure that the SQL service account has access. Note that it is possible to have a dir that administrator has...

    April 2, 2009 at 8:18 am

    #970734

  • RE: Checkdb failure

    GSquared (4/2/2009)

    Looks like your system doesn't have access to the file. Check the account SQL is running under and make sure it has full access to the directory in...

    April 2, 2009 at 7:54 am

    #970700

  • RE: View SQL 2000 jobs through Management Studio

    I've been working on getting our developers out of db_owner and this is one of the problems I've encountered. Even with them being a member of the TargetServersRole I...

    November 17, 2008 at 10:22 am

    #899450

  • RE: Linked Server Dependencies

    Just a couple of changes are required for this to work properly in my environment.

    I added a where clause on kerser2 WHERE ISREMOTE = '1'

    And I changed the search of...

    October 15, 2008 at 8:53 am

    #885288

  • RE: Linked Server Dependencies

    Runs fine for me.

    October 15, 2008 at 8:06 am

    #885227

Viewing 13 posts - 76 through 88 (of 88 total)