Viewing 15 posts - 901 through 915 (of 1,318 total)
Yes, you have to restore the full backup first or you won't be able to restore that differential.
August 7, 2014 at 2:19 am
Just do it the same way you did the default instance!
I know, why don't you tell us what you did and we can comment- or is this in fact...
August 5, 2014 at 5:02 am
Koen Verbeeck (8/5/2014)
Grant Fritchey (8/5/2014)
You get a phone call. The person on the phone says the database is slow. What do you do?
Migrate from Oracle to SQL Server? Do I...
August 5, 2014 at 4:41 am
Just the same way as for the default instance. Have you encountered an error message, or something?
August 5, 2014 at 3:43 am
Or copy the files to an external drive and courier/drive it to the new location.
😀
It genuinely can be quicker to get on a plane with a hard drive yourself.
August 1, 2014 at 7:44 am
I love it! Always compact and repair your SQL Server databases :-D!
July 31, 2014 at 4:59 am
I'd probably just delete and set up log-shipping again, to be honest.
July 31, 2014 at 4:14 am
When you are looking for a new job, and agency recruiter calls you to invite to meet him/her at the agency office, did you find it useful? Do they really...
July 30, 2014 at 9:40 am
This thread is hysterical :-D.
July 30, 2014 at 6:18 am
That's great. Good luck. Get as much real-world experience as you can, and keep us posted :-).
July 24, 2014 at 9:31 am
I agree, start with the Stairways on this site. You probably won't be able to leap straight into the Microsoft certification books (I don't mean that rudely; they do assume...
July 24, 2014 at 9:12 am
I do a restore with move, as suggested above, and rather than setting to single user mode, I set to restricted_user mode;
use master
go
alter database destinationdbname
set restricted_user with rollback immediate
(then do...
July 24, 2014 at 2:45 am
Yes, just set it up again from scratch. It's probably going to be quicker.
July 24, 2014 at 2:20 am
Eirikur Eiriksson (7/20/2014)
jbnv (7/20/2014)
July 21, 2014 at 2:09 am
we can not find who has done such type of activity. Because for every user it will be showing same username
Why's that?
July 18, 2014 at 4:27 am
Viewing 15 posts - 901 through 915 (of 1,318 total)