Viewing 15 posts - 1 through 15 (of 139 total)
We have found that virus scanners can sometimes cause this sort of problem..
James
August 7, 2009 at 10:39 am
The transaction log is not an audit log.. I wouldn't want to have to actually do it as I'm sure there are plenty of consistency checks but several companies (including...
August 7, 2009 at 10:37 am
You just need to grab the script and add they keyword COPY_ONLY to it.. IE set up the backup via SSMS and hit Ctrl-Shift-C rather than OK then paste into...
August 7, 2009 at 10:23 am
Charles,
Copy-only backups were around in SQL Server 2005 (http://msdn.microsoft.com/en-us/library/ms191495(SQL.90).aspx) or is there some other new functionality I have missed?
[Edit to make link]
James
August 7, 2009 at 10:07 am
These (well at least the latter of the errors) looks like it could be a permissions problem. Does your SQL Server user have access to the file share you want...
August 7, 2009 at 7:00 am
NTFSUndelete or similar software might have been a better first option. When you delete a file the inodes are cleared but the data isn't and can often be recovered (although...
August 7, 2009 at 6:14 am
Ninja,
I don't work on SQL Server Central - I wanted to but due to my name not being Steve I am not allowed near the code base..
I just couldnt...
September 29, 2007 at 8:44 am
My mother lives in a farm down in Somerset, they have an old industrial furnace which heats the water and provides central heating to the house - every few years...
September 26, 2007 at 4:12 am
Steve,
I have the same behaviour here.. I'll go and see the other two Steves about it.
James
September 26, 2007 at 2:10 am
Hi Brian,
You might be better off in our dedicated support forums - http://www.red-gate.com/messageboard/viewforum.php?f=64. It will then be tracked by our support department properly rather than being answered by a...
August 23, 2007 at 8:04 am
I would turn on perfmon and monitor reporting services' and SQL Servers memory usage and see if it peaks just before a crash happens. There might be a report which...
August 20, 2007 at 8:27 am
Is there anything logged in the activity/error log?
James
August 20, 2007 at 7:48 am
If you are using SQL 2005 you want to have a look at Common Table Expressions (CTE's) otherwise have a look for recursive queries there are lots of questions/articles about...
August 20, 2007 at 4:36 am
Hi subu,
WITH NO RECOVERY leaves the database offline so you cannot modify it and it is then safe to apply further backups to the database. WITH RECOVERY brings the database...
August 19, 2007 at 2:50 am
Viewing 15 posts - 1 through 15 (of 139 total)