Viewing 15 posts - 901 through 915 (of 991 total)
I'm not sure I understand your question. Are you asking whether full backups are possible in SIMPLE recovery mode? Yes - but you cannot take log backups too so your...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 14, 2007 at 7:52 pm
There is no way to do what you want except with an intermediate step similar to you have. It's a commonly requested feature. The problem is that the database size...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 12, 2007 at 5:17 pm
Only by using the undocumented log scanning function fn_dblog, and only if the log record you're interested in hasn't been truncated from the log. It's complicated but do-able.
If you want...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 12, 2007 at 5:11 pm
Good topic for a contraversial blog post. See BACKUP LOG WITH NO_LOG - use, abuse, and undocumented trace flags to stop it and SQL Server 2008: What's been removed in...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 12, 2007 at 1:34 pm
Kimberly also just wrote a blog post last week about her preferred architecture for partitioning a table into two tables - one with read-only partitions and one with a single...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 12, 2007 at 9:41 am
You can use profiler to do this - checkout Data File Auto Grow in Books Online.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 12, 2007 at 9:35 am
Going from 2000 to 2005 we rewrote some of the backup internals around multi-threaded scheduling and buffer management (backup uses its own schedulers inside SQL Server) - this may account...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 12, 2007 at 9:08 am
I did a blog post about this a few days ago - Search Engine Q&A #7: Restoring from a backup file containing multiple database backups
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 12, 2007 at 9:05 am
One thing to be aware of - the TRUNCATE_ONLY and NO_LOG options have been removed in SQL Server 2008. We tried to remove them in 2005 too but they go...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 11, 2007 at 4:30 pm
TheSQLGuru (10/11/2007)
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 11, 2007 at 11:53 am
Nipa also sent me email - I gave her some more links:
- A video recording of my Secrets of Fast Detection and Recovery from Database Corruptions talk from TechEd this...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 11, 2007 at 11:49 am
ok - cool. No offense - just that I've seen a bunch of posts on various forums who are advertizing their product without giving any extra advice. And yes, on...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 10, 2007 at 1:57 pm
Yes, you can do it using sqlcmd.
Inside the script, you use the following syntax (an example from setting up database mirroring using such a script)
:SETVAR PrincipalServer (local)\SQLDev01
:SETVAR MirrorServer (local)\SQLDev02
:SETVAR WitnessServer...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 10, 2007 at 1:43 pm
Why do you keep going on about SQL Log Rescue? There is no log recovery tool on the market that copes with everything in the SS2005 transaction log.
What are you...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 9, 2007 at 11:34 pm
Very interesting - and who do you work for? Looks a bit like advertizing to me.
I've seen many of these come and go while in the SQL team - rarely...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 9, 2007 at 11:31 pm
Viewing 15 posts - 901 through 915 (of 991 total)