December 1, 2015 at 11:43 am
Hi All,
it appears that I inadvertantly added a second file when creating a back up of a database the other day. I was changing the back up location, and seems that i didn't remove the original file.
The problem is, that i now can't back up the database, as it always complains that it wants the second file. I have tried removing all the files from the list, and then readding the one I want, but to no avail. I have even tried putting a different file path for the 2nd file in, but tit then tells me that the new file isn't the file it wanted.
Can anyone advise how i reset the database to accept only one media file? I'm kind of pulling my hair out now, and getting the the stage where I'm fearful I need to delete the whole db and start all over again 😥
Thanks all.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 1, 2015 at 12:25 pm
BACKUP ... WITH INIT;
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply