Viewing 15 posts - 15,571 through 15,585 (of 49,552 total)
Attach will fail, no matter how you specify it because, as the earlier error said, the database was not cleanly shut down before the log was lost. Without a log,...
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
November 20, 2012 at 11:55 pm
That's just a generic 'something went wrong' message.
So the scheduled backup succeeds (backup file written, correctly, complete and restorable) but the job is marked as failed?
Does the job step succeed?
If...
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
November 20, 2012 at 2:21 pm
Perry Whittle (11/20/2012)
GilaMonster (11/19/2012)
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
November 20, 2012 at 2:10 pm
hi2u (11/20/2012)
t i always thought this was not true because of this : http://dbaspot.com/ms-sqlserver/140553-transaction-deadlock-tablelocks.html
That thread's talking about SELECT and the locks it takes. You're talking about UPDATE. Very different...
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
November 20, 2012 at 11:19 am
hi2u (11/19/2012)
For this scenario :
update Table1 with (TABLOCK, XLOCK)
...
then a "INSTEAD OF TRIGGER" on Table1 update Table1 with other value
Does the trigger keep the initial (TABLOCK, XLOCK) or the...
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
November 20, 2012 at 9:10 am
ramyours2003 (11/20/2012)
how to take the sql objects (tables, SP's) in to single user mode in a database
You can't take objects into single user mode. Only the entire database or the...
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
November 20, 2012 at 8:55 am
Restart the SQL Server. As has been pointed out more than once, you cannot safely shrink an in-use TempDB, you need to completely and totally quiesce the server (no operations,...
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
November 20, 2012 at 6:16 am
nitin.doshi (11/20/2012)
This being our production server we are looking alternatives without restarting SQL service.
Leave it as is?
If tempDB grew that size, then, unless there was some unusual activity, it suggests...
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
November 20, 2012 at 4:39 am
Maybe, but I meant deleting smaller chunks in a while loop.
Have a search for batched deletes, should find you something
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
November 20, 2012 at 2:32 am
Delete in smaller chunks.
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
November 20, 2012 at 2:15 am
Nope.
Simple and bulk-logged allow for minimal logging
Bulk-logged and full allow for log backups
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
November 20, 2012 at 2:09 am
No, it'll make it worse or no change at all.
Simple recovery - minimal logging, log truncated on checkpoint
Bulk-logged recovery - minimal logging, log truncated on log backup (if a full...
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
November 20, 2012 at 2:02 am
System databases cannot be mirrored, only user databases.
You probably want to copy over logins, jobs, etc, but it can't be done by mirroring the DBs.
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
November 20, 2012 at 1:55 am
Ratheesh.K.Nair (11/20/2012)
Thanks Everyone.Do we need to take any kind of backup when changing database recovery model from SIMPLE-->BULK LOGGED-->SIMPLE
My first question would be why you're changing the recovery model to...
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
November 20, 2012 at 1:55 am
tafountain (11/19/2012)
Use multiple backup files (up to 1 per CPU)
I wouldn't necessarily recommend this.
If you're going to stripe your backups, stripe based on how many IO paths you have (if...
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
November 19, 2012 at 1:02 pm
Viewing 15 posts - 15,571 through 15,585 (of 49,552 total)