Viewing 15 posts - 16 through 30 (of 34 total)
Thanks for all the responses.
Problem I have is that lots of rows got inserted/deleted over the course of five days. Always it was insert/delete, so I'm thinking...
April 23, 2013 at 12:23 pm
When you say "restore your database" do you mean from the original backup or from the one taken after the insert/delete occurred?
As I'm typing that it sounds like a...
April 23, 2013 at 9:11 am
Sorry that was not quite correct.
Here is the actual sequence.
Database was backed-up/restored to this server.
Data was inserted/deleted
Full backup taken.
April 23, 2013 at 8:51 am
Hi,
That's what I thought.
I do have a full backup but as I'm trying to recover rows that were inserted and deleted within seconds I'm assuming they are gone for...
April 23, 2013 at 8:29 am
The database was created, the data inserted and then deleted and then a full database backup performed. There was no differential and/or transaction log backups performed.
April 23, 2013 at 8:22 am
e4d4 (2/1/2013)
Check, and find a one difference:
DECLARE @Person TABLE (Name nvarchar(100)COLLATE SQL_Latin1_General_CP1_CI_AS);
INSERT INTO @Person VALUES(N'Çaliskan Akdag');
SELECT * FROM @Person;
Ahhh, of course N''. Thanks!...
February 1, 2013 at 7:35 am
GilaMonster (1/29/2013)
Grow that log file to something sensible, and make sure that the autogrow settings aren't the default.
Hi, yes I will. It was just on a test version of...
January 29, 2013 at 2:03 am
SQLALX (1/28/2013)
How to shrink transaction log file: http://bit.ly/XaDOQr
Ok, I followed all the steps in that article and it did indeed shrink the logfile down to 1mb.
So...
January 29, 2013 at 1:40 am
ScottPletcher (1/28/2013)
SELECT log_reuse_wait_desc, * --col name may be a little off, from memory, but it's at least close
FROM sys.databases
WHERE name =...
January 29, 2013 at 1:12 am
Ian Scarlett (1/11/2013)
The fact that you can't see anything would lead...
January 11, 2013 at 7:27 am
Ah, sorry I see what you mean. I did put a select @sql in but nothing came back to SSMS, thin that might be because the procedure...
January 11, 2013 at 7:01 am
Hi,
Yes the command works fine when copied out of the text visuaizer in VS2010 debugger into SSMS . The usp_DateParts_Get puts hyphens in the date, that's why it's 10...
January 11, 2013 at 5:56 am
I did, also copied the full command from the debugger to see if it worked, it did.
January 11, 2013 at 5:37 am
n00bDBA (11/6/2012)
November 6, 2012 at 1:42 am
You can try Redgate's SQL Tab Magic (currently free if I'm not mistaken), it does what you want from SSMS and even better 🙂
It also keeps track of tabs you...
November 6, 2012 at 1:00 am
Viewing 15 posts - 16 through 30 (of 34 total)