Viewing 15 posts - 4,951 through 4,965 (of 7,506 total)
- I think you've posted in the wrong forum (sql2005 backup)
- what kind of isolation level are your applications using.
avoid repeateble read as much as you can.
sp_blocker_80 shows 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
April 19, 2008 at 9:31 am
- did you try just adding the correct date to both columns ?
- and then just query
datediff(MINUTE , startdate, enddate) as elapsttime_Minutes
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
April 18, 2008 at 12:55 pm
well ... maybe the are ...
try to add an "order by 1,2,3 " at the sqlserver side as wel as at the access side.
Maybe then you'll see the data is...
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
April 18, 2008 at 12:51 pm
- is that database configured "autoclose on" ?
- if yes, it needs a restore-step to be opened again.
(keep in mind SSMS doesn't autorefresh the object-browser pane)
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
April 18, 2008 at 11:11 am
- is your sqlserver "member" object a view or a table ?
If it is a view, can you post the ddl ?
-Are you using a linked table to...
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
April 18, 2008 at 11:09 am
did you check http://www.sqlservercentral.com/Forums/Topic459602-148-1.aspx ?
or
http://www.sqlservercentral.com/Forums/FindPost328227.aspx
or http://www.sqlservercentral.com/articles/OpenDataSource/61552/
or http://www.sqlservercentral.com/Forums/Topic475347-8-1.aspx
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
April 18, 2008 at 5:11 am
I'm glad you found the issue and were able to fix it.
You could also have granted full control or the service account to the folder that contains the logfiles.
But that...
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
April 18, 2008 at 5:05 am
The little test ...
/*
use master
alter database SSC_TestBU set read_only with rollback immediate;
drop database SSC_TestBU;
alter database SSC_TestRcvr set read_only with rollback immediate;
drop database SSC_TestRcvr;
...
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
April 18, 2008 at 3:56 am
- What do you use to read the xls file ?
- did you try using DTS ?
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
April 18, 2008 at 3:00 am
- keep your head cool ( if you don't, no one else will do it for you !)
- have a look a sqlserver errorlog file and search for anomalies
- take...
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
April 18, 2008 at 2:58 am
- off course you cannot apply previous log-backups to the new full backup.
- every full backup starts a new recovery "cycle".
- For SQL2005 there is this new "copy_only" parameter that...
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
April 18, 2008 at 2:49 am
Marios Philippopoulos (4/17/2008)
...invoked from a SQL job ....
Especialy in that case, put it in a effective .net application or SSIS package and don't poison your db-server with it !
Prepare 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
April 17, 2008 at 7:54 am
you may want to have a look at fn_split kind of functions .
Maybe they may provide what you look for without using dynamic sql.
have a look at :
http://www.sqlservercentral.com/scripts/Miscellaneous/30225/
http://www.sqlservercentral.com/scripts/String+Manipulation/61509/
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
April 15, 2008 at 1:26 pm
Is someone using the "copy database" wizard ?
It proposes a "detach - attach" scenario. :sick:
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
April 15, 2008 at 6:29 am
Be happy it's only the clr going down.
I've had a whole instance going down when activating a memory hog CLR function.
http://www.sqlservercentral.com/Forums/FindPost457289.aspx
IMO This is one of the reasons to avoid CLR...
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
April 15, 2008 at 6:25 am
Viewing 15 posts - 4,951 through 4,965 (of 7,506 total)