Viewing 15 posts - 22,291 through 22,305 (of 49,552 total)
assefam (11/11/2011)
The question is we have log backup before 5 days
Doesn't matter. If you have no full backup (or diff) after the point you deleted the log file & recreated...
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 11, 2011 at 11:20 am
assefam (11/11/2011)
I didn't take any single backup after that
Then the best you can do here is restore from that 5 day old backup and accept that 5 days of data...
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 11, 2011 at 11:06 am
daveriya (11/11/2011)
hiok i found it under database but in different schema,how to change schema to dbo
DROP and recreate (and specify the schema) or use ALTER SCHEMA to transfer the object.
ALTER...
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 11, 2011 at 10:21 am
assefam (11/11/2011)
Immediately after the back up, we created new log file and deleted the previous large log file keeping the mdf file as it is.
Sorry, what???? Detach, delete ldf,...
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 11, 2011 at 10:16 am
Ninja's_RGR'us (11/11/2011)
... and did you take ANY single log backup after the full?
And if so, do you have that log backup?
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 11, 2011 at 10:13 am
MSDB - sysjobs, sysjobhistory and the sysbackup* tables.
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 11, 2011 at 10:12 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1204362-391-1.aspx
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 11, 2011 at 10:11 am
No log backup in 5 days, your log must have grown huge.
Or have you been manually truncating it or switching to simple recovery and back to full? Important, I need...
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 11, 2011 at 9:58 am
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 11, 2011 at 9:55 am
Ok, great, so it's a normal database backup.
Now, my other question:
Do you have log backups? If not, how are you managing your transaction 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 11, 2011 at 9:54 am
Revenant (11/11/2011)
If you add 2005-specific features (such as indexed views), you cannot.
You can always change the compatability level. There are no checks for doing so. Some stuff (that uses newer...
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 11, 2011 at 9:52 am
To give you an idea about how the compat level works, I'm busy compressing indexes (a SQL 2008 feature) in a database set to compat mode 90 (sql 2005). Working...
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 11, 2011 at 9:50 am
Change it back to checksum.
Some 2005 features are fine, some are not. The ones that are not purely have to do with the query processor. It's only the query processor...
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 11, 2011 at 9:42 am
assefam (11/11/2011)
Please Help: Is it possible to take buckup from Log file with out bring DB online. For your information, the real data is not available
I need you to answer...
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 11, 2011 at 9:37 am
daveriya (11/11/2011)
i am connected to the right server,i am able to execute it,but its not showing in the list
Is object explorer connected to the same server and pointing at 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 11, 2011 at 9:32 am
Viewing 15 posts - 22,291 through 22,305 (of 49,552 total)