May 18, 2015 at 9:51 pm
SQLRNNR (5/18/2015)
So, thinking about that thread that Lynn finally helped resolve, I think some pain could have been saved.Looking at an earlier post by the OP, enough info was provided to be able to create the restore command (from the 8th post in the thread).
briancampbellmcad (5/15/2015)
I tried changing it to 'BCCrestored' but it didn't create that DB and multiple errors popped up:RESTORE DATABASE BCCrestored FROM DISK = '\\Belmont\c$\BCC_DB_backup_201505030017.bak'
GO
Msg 1834, Level 16, State 1, Line 1
The file 'D:\Databases\Data\BCC.mdf' cannot be overwritten. It is being used by database 'BCC_DB'.
Msg 3156, Level 16, State 4, Line 1
File 'BCC' cannot be restored to 'D:\Databases\Data\BCC.mdf'. Use WITH MOVE to identify a valid location for the file.
Msg 1834, Level 16, State 1, Line 1
The file 'D:\Databases\Data\BCC_log.ldf' cannot be overwritten. It is being used by database 'BCC_DB'.
Msg 3156, Level 16, State 4, Line 1
File 'BCC_log' cannot be restored to 'D:\Databases\Data\BCC_log.ldf'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
From this, one could quickly come up with the following command...
RESTORE DATABASE BCCrestored FROM DISK = '\\Belmont\c$\BCC_DB_backup_201505030017.bak'
/* belmont was apparently the workstation name */
WITH MOVE 'BCC' TO 'D:\Databases\Data\BCCrestored.mdf'
/* provided by the error message and just updated to rename the in-use file */
,MOVE 'BCC_Log' TO 'D:\Databases\Data\BCCrestored_log.ldf'
/* provided by the error message and just updated to rename the in-use file */
,REPLACE --unnecessary since BCCrestored did not exist unlike BCCRestore, but harmless here
,BUFFERCOUNT = 75
,STATS = 5 --stats unnecessary unless op is trying to predict finish
GO
So maybe, if we slow down a bit sometimes, we can save the OP and ourselves some hair tugging.
Problem was he took that and changed everything to UNCs using with the admin share. Then, when it was noticed there was a typo, he kept using it as is with the typo instead of fixing it.
Then he also thought that the command as posted was for doing a restore to the local box not the server.
May 19, 2015 at 3:21 am
Caught up after a week in Lisbon.
A few days holiday then the SQL Sat there. Paul White pre-con / training day. Good session, good event overall. And managed to chat with Paul for about 10 minutes 🙂 Although it may take a long time to forgive him for thinking I was someone else... :-O
Gail, agree with everyone else A. Go for it.
Saint Lynn again comes to the rescue. Well done all for getting the OP to where they needed to be.
Steve, with a bit of luck I'll have the shots of you from SQL Bits up on my Onedrive for you to copy. Gail indirectly reminded me I hadn't done this 😉 And it's a long weekend this weekend in the UK.
Cheers,
Rodders...
May 19, 2015 at 3:36 am
GilaMonster (5/14/2015)
Question for the people here...Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when I started it that was a condition my boss required (no link whatsoever to the bank I worked for then) and partially because I hate sites of the form 'here's a scrap of info, pay me for the rest'.
I'm considering changing that, adding a bit to the side bar advertising my services, mostly database tuning, and maybe books I've written/contributed to and probably more later on.
What are your feelings?
A) Why didn't you do that years ago?
B) Meh, ok, if you must.
C) I will never read your blog again!!1!!!11!!!
A, definately.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 19, 2015 at 12:05 pm
"Really? You can't help me based solely on the brief description and current output of my query?"
Why are people so reluctant to help us help them?
May 19, 2015 at 12:08 pm
Lynn Pettis (5/19/2015)
"Really? You can't help me based solely on the brief description and current output of my query?"Why are people so reluctant to help us help them?
Sorry, my hands and feet are tied, I can't lift the silver spoon myself.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 19, 2015 at 3:41 pm
SQLRNNR (5/19/2015)
Lynn Pettis (5/19/2015)
"Really? You can't help me based solely on the brief description and current output of my query?"Why are people so reluctant to help us help them?
Sorry, my hands and feet are tied, I can't lift the silver spoon myself.
Fighting the urge to ask if the op even wants some help.
May 19, 2015 at 4:07 pm
Lynn Pettis (5/19/2015)
SQLRNNR (5/19/2015)
Lynn Pettis (5/19/2015)
"Really? You can't help me based solely on the brief description and current output of my query?"Why are people so reluctant to help us help them?
Sorry, my hands and feet are tied, I can't lift the silver spoon myself.
Fighting the urge to ask if the op even wants some help.
Is it me or am I not seeing the latest posts by the OP?
May 19, 2015 at 4:58 pm
Lynn... If you want to take a crack at this one (Case Sensitive Collation Causing Cardinality Warning), you have my word, I'll respond in a timely manner... As an added bonus, I was taught to say "Thank You" when people help. 😀
May 20, 2015 at 4:08 am
AAAAAARRRRRRGGGGGGGHGHGHGHGHGHGH!!!!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 20, 2015 at 5:17 am
Grant Fritchey (5/20/2015)
AAAAAARRRRRRGGGGGGGHGHGHGHGHGHGH!!!!
Dare we ask?
May 20, 2015 at 5:41 am
Lynn Pettis (5/19/2015)
SQLRNNR (5/19/2015)
Lynn Pettis (5/19/2015)
"Really? You can't help me based solely on the brief description and current output of my query?"Why are people so reluctant to help us help them?
Sorry, my hands and feet are tied, I can't lift the silver spoon myself.
Fighting the urge to ask if the op even wants some help.
I think it's more-so that the brain is too tired to lift the silver spoon. You should probably just write it yourself and release it to their server for them so they don't have to be bothered with their own problem. 😉
May 20, 2015 at 5:41 am
Brandie Tarvin (5/20/2015)
Grant Fritchey (5/20/2015)
AAAAAARRRRRRGGGGGGGHGHGHGHGHGHGH!!!!Dare we ask?
How about a link? You're normally so patient that it ought to be good. 😛
May 20, 2015 at 6:12 am
Ed Wagner (5/20/2015)
Brandie Tarvin (5/20/2015)
Grant Fritchey (5/20/2015)
AAAAAARRRRRRGGGGGGGHGHGHGHGHGHGH!!!!Dare we ask?
How about a link? You're normally so patient that it ought to be good. 😛
We've been beating this person about the face & neck over several days. Little is getting through.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 20, 2015 at 8:54 am
Grant Fritchey (5/20/2015)
Ed Wagner (5/20/2015)
Brandie Tarvin (5/20/2015)
Grant Fritchey (5/20/2015)
AAAAAARRRRRRGGGGGGGHGHGHGHGHGHGH!!!!Dare we ask?
How about a link? You're normally so patient that it ought to be good. 😛
We've been beating this person about the face & neck over several days. Little is getting through.
And here I was, hoping that it was already September 19th[/url] 😛
May 20, 2015 at 9:07 am
Again...
AAARRARARRGGGGHHHH!!!
Sometimes, I just wonder why any of us even try. Reams of good advice from multiple people. All of it ignored. Apply a random query hint. Things are a little better. WIN!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 48,466 through 48,480 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply