Viewing 15 posts - 27,751 through 27,765 (of 49,552 total)
irobertson (2/15/2011)
Never. I might not be a DBA, but I'm also not a *complete* idiot 😀
😀
We're so used to DBAs with no backups of production databases that many of us...
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
February 15, 2011 at 7:18 am
So you're looking at the vicinity of 1 TB without any additional calculations.
Size of backup = size of data in database + size of portion of log needed for 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
February 15, 2011 at 7:16 am
Yes.
The database is in simple recovery model. No log backups are possible. Upon switch to full recovery you will have to take a full backup before you start taking...
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
February 15, 2011 at 6:25 am
Kiara (2/15/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
February 15, 2011 at 6:04 am
Lol. Varchar(300) methinks?
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
February 15, 2011 at 5:30 am
You do not have the full transaction log since the last backup. Since the database was in simple recovery, the log would have been getting truncated whenever a checkpoint ran...
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
February 15, 2011 at 5:07 am
The only stats you'll need to update are the column statisics (ones not associated with indexes) as the ones that are associated with indexes will be recreated with the index.
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
February 15, 2011 at 5:01 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
February 15, 2011 at 4:22 am
joydeep.das.mail (2/15/2011)
I need 70-445 brain dumps
Dumps are cheating. They are actual questions taken from the real exams. Using or distributing them can result in your certifications being revoked and even...
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
February 15, 2011 at 4:22 am
A simple update would not give you that. There must be something else in the procedure that's causing that error.
Post the full error message and check what's on the line...
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
February 15, 2011 at 4:10 am
Not a trivial question...
How long do you intend to retain backups on disk before copying to tape/offsite storage?
Do you intend to do log backups (for point-in-time restores) and if 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
February 15, 2011 at 3:09 am
Define 'didn't worked'
Snapshot isolation works fine with all DML statements.
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
February 15, 2011 at 2:57 am
There's a utility to rebuild the master database. You will lose all logins, all server-level roles and permissions, all linked servers, you'll have to reattach all user databases.
Google for rebuild...
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
February 15, 2011 at 2:20 am
Not necessarily a good idea.
TL is a text column (should be changed to varchar(max) as text is deprecated). If you include that, you are duplicating the entire column. The entire...
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
February 15, 2011 at 2:19 am
Have a read through this: http://www.sqlservercentral.com/articles/Indexing/68563/
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
February 15, 2011 at 2:17 am
Viewing 15 posts - 27,751 through 27,765 (of 49,552 total)