Viewing 15 posts - 22,966 through 22,980 (of 49,552 total)
Spam. Reported. No replies please.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 13, 2011 at 12:01 am
Spam. Reported. No replies please.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 13, 2011 at 12:00 am
Spam. Reported. No replies please.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 13, 2011 at 12:00 am
Nope. To restore that, you need the 1.6TB of space.
Or buy a 3rd party tool like SQL Virtual Restore.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2011 at 11:53 pm
SQL will try to put the pages down in physical order within the data file, but it is by no means guaranteed that it will be able to do so,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2011 at 11:39 pm
And, what are you looking for? The script to do this? A way of automating a script you have?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2011 at 7:57 am
Perry Whittle (10/12/2011)
do you have any log backups happening outside of the log shipping plan?
If there was, the error would be that the log backup is too new to apply...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2011 at 7:56 am
That log backup file is damaged and hence not restorable.
You're going to have to take a full or diff backup of the source, restore over the secondary and then delete...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2011 at 7:56 am
What are those snapshots used for?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2011 at 7:54 am
That message typically means that someone clicked the 'stop' button for the service or an app called for a NET STOP <service name>.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2011 at 7:52 am
Perry Whittle (10/12/2011)
mwieczorek (10/12/2011)
any ideas why my sql server restarts every time?
As I said it sounds like someone is pulling the plug or switching off at the socket. Without any...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2011 at 12:57 am
SQL Stud (10/11/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2011 at 12:49 am
Of course it's true, that's one of the fundamental points of an index, that the data at the leaf level is logically ordered by the key columns. If it wasn't,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2011 at 12:41 am
You can try dropping them both and then recreating them both. It's possible that the drop will fail.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 11, 2011 at 2:39 pm
Lexa (10/11/2011)
Evil Kraig - so do you get any performance gains from NOLOCK while using Snapshot isolation?
Unlikely, and you get all the dirty data problems same as if you weren't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 11, 2011 at 2:38 pm
Viewing 15 posts - 22,966 through 22,980 (of 49,552 total)