Viewing 15 posts - 33,751 through 33,765 (of 49,552 total)
Just take full backups weekly (or daily). Same with model. As Lynn pointed out, you can't take log backups of master and model should almost never change.
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
March 1, 2010 at 1:10 pm
Because restore history is the restore from backup history, not reverting to a snapshot.
Is this a production server? If so, why is a dev creating and reverting snapshots?
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
March 1, 2010 at 12:52 pm
emily-1119612 (3/1/2010)
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
March 1, 2010 at 12:45 pm
Someone's either run Backup Log with truncate only or has switched the DB into simple recovery and back. Those two things will break the log chain.
Both will be logged 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
March 1, 2010 at 12:35 pm
No one interested in the soccer world cup?
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
March 1, 2010 at 12:29 pm
Both will transfer the database users. They're stored in the database, hence they move with the database.
Neither will transfer the login information. That you'll have to script out, preferably with...
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
March 1, 2010 at 10:43 am
Excellent
It was kinda interesting watching the twitter comments, with people rooting for both sides, without actually watching the game.
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
March 1, 2010 at 10:12 am
Who actually won the hockey yesterday?
I went to bed before it was finished and didn't feel like wading through hundreds of twitter updates this morning.
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
March 1, 2010 at 10:01 am
GSquared (3/1/2010)
It's "DBCC Log()". The parameters that I know of are the database name and a numeric "style" that determines the columns you get back.
SELECT <column list> FROM fn_dblog(null,...
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
March 1, 2010 at 9:40 am
No services need to be stopped to detach and attach a database. Just note that the DB will be unavailable while the copy is in process.
Backup/restore is a better option,...
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
March 1, 2010 at 9:37 am
If you want to track transactions and changes, you're better off using triggers or a SQL trace. The transaction log was never intended to be human readable, if you want...
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
March 1, 2010 at 9:35 am
Does master change so often that you need it in full recovery and log backups being taken? Same goes for model?
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
March 1, 2010 at 9:00 am
RalphWilson (3/1/2010)
As far as I am concerned, a non-clustered PK is, in reality, a non-clustered Unique Key.
There are some fundamental differences between a primary key and a unique constraint, not...
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
March 1, 2010 at 8:56 am
RalphWilson (3/1/2010)
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
March 1, 2010 at 8:34 am
Have a look at Andrew Kelly's stuff. His blog is here: http://sqlblog.com/blogs/andrew_kelly/, I think he's written stuff for SQL Mag and other places.
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
March 1, 2010 at 8:15 am
Viewing 15 posts - 33,751 through 33,765 (of 49,552 total)