December 11, 2006 at 1:59 am
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
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