Viewing 15 posts - 2,866 through 2,880 (of 7,499 total)
Is this a level 90 database ?
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 8, 2010 at 1:48 pm
- We create the backup file on the production server.
- Copy that file to safezone. (next step of the backup job)
This is scheduled at 19:30
On some of our dev...
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 8, 2010 at 1:42 pm
SKYBVI (9/8/2010)
RESTORE DATABASE XYZ
FROM DISK = 'E:\xyz_backup_201009022015.bak'
WITH MOVE 'logical_name.mdf' TO 'E:\SQLDatabases\XYZ.mdf',
MOVE 'logical_name.ldf' TO 'E:\SQLLogs\XYZ.ldf',
STATS=5
I recevied error:-
Msg 64, Level 20, State 0, Line 0
A transport-level error has occurred when receiving...
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 8, 2010 at 8:03 am
GilaMonster (9/8/2010)
Now here's an interesting question...Which is going to reach 20 000 posts first, me or the Thread?
Hurry up 😀
must be a photofinish :hehe:
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 8, 2010 at 7:58 am
Hi Steve , I hope you're not on the run for the forrest fire issues near Denver.
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 8, 2010 at 7:01 am
Thanks. Just making sure I didn't misinterprete it.
So, Ioana there is still a aftermath to do after the db got back online.
The provided urls should get you on track.
Simplefied steps:
--...
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 8, 2010 at 6:54 am
Did you try your restore using the "restart" parameter ?
I've had a similar issue with a bak file >99Gb.
If I'm correct, it was related to some W2003 32bit bug...
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 8, 2010 at 6:28 am
Hi Gail, Sorry for hopping in but would this be a typical case of VLF fragmentation ?
ref: Monitoring SQL Server Virtual Log File Fragmentation
Performance impact: a large number of...
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 8, 2010 at 6:20 am
- what kind of size are we talking about (current , target) ?
- how long did you wait for it to complete ?
- check (b)locking when you run dbcc shrinkfile...
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 7, 2010 at 12:04 am
You mean in the DDL of these objects ?
check database triggers !
e.g. http://www.sqlservercentral.com/scripts/DDL+Triggers/64536/
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 6, 2010 at 12:45 am
If it's a huge database you can add the "restart" parameter to your (original) restore statement, and it will pick it up where it got killed.
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 4, 2010 at 2:16 am
Make it "foolproof" and they'll come up with a better fool 😀
Thumbs up for the new job ...
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 3, 2010 at 5:01 am
Damon Falconi-345992 (9/1/2010)
http://support.microsoft.com/kb/2261464
I applied this and it resolved the issue... If you wade through the...
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 3, 2010 at 1:29 am
Thank you for sharing your findings and observations.
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 2, 2010 at 3:08 am
karmour (9/1/2010)
http://support.microsoft.com/kb/2265716
We did these late last week and we...
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 1, 2010 at 1:22 pm
Viewing 15 posts - 2,866 through 2,880 (of 7,499 total)