Post reply

Database File

  • December 11, 2006 at 1:59 am

    #193437

    Dear All,

    There's a database that was installed on the server but then it was created in separate folder the  backups are also in separate folder,they were not stored in default sqlserver folders. Now the problem is that there is a database file of this specific database that is in the default datafile of the sever, I deleted it last week as it taking too much space on the server, but this morning I found that it was created on friday night. It is 7GB larger than the database that we use even though it's they are boht same database. I find it very strange on how it happened, please help me solve this problem.

     

  • December 11, 2006 at 3:19 am

    #677152

    is this a backup file ?

    If yes, maybe there is a backup-device pointing to it ...

    exec sp_helpdevice

    you can rerout it using

    begin tran

    exec sp_dropdevice @logicalname = 'yourdevicename'

    exec sp_addumpdevice  @devtype = 'disk', @logicalname =  'yourdevicename', @physicalname = 'yourpathandfilename'

    commit tran

    They may have embedded their backup-comands in stored procs, you may want to search them for "backup". there are queries at SSC to seach on proc-text.

    They may have created their own backup-job, take a look at sqlagent jobs to find it. there are queries at SSC to seach on this.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply