Viewing 15 posts - 1 through 15 (of 19 total)
Your code is definitely simpler. But the performance (at least on my machine) is lacking. I just stopped it after letting it run for 10 minutes. My table has about...
_______________________________________________________________________________________________
Bob Pusateri
Microsoft Certified Master: SQL Server 2008
Blog: The Outer Join[/url]
Twitter: @SQLBob
February 17, 2014 at 8:27 pm
Thanks for all the tips! I came up with a multi-step solution that so far seems to get me what I need, and I'm happy to share. I'll do a...
_______________________________________________________________________________________________
Bob Pusateri
Microsoft Certified Master: SQL Server 2008
Blog: The Outer Join[/url]
Twitter: @SQLBob
February 17, 2014 at 7:12 pm
Alright, after much more experimentation, it turns out that what I'm trying to do *can* work, provided that the formatting of the log backup file names exactly matches what log...
_______________________________________________________________________________________________
Bob Pusateri
Microsoft Certified Master: SQL Server 2008
Blog: The Outer Join[/url]
Twitter: @SQLBob
January 14, 2014 at 2:40 pm
You are correct, but the metadata is all there. I populated it with the log shipping stored procedures as detailed in BOL:
http://technet.microsoft.com/en-us/library/ms188708(v=sql.105).aspx
If the metadata wasn't there, nothing would work at...
_______________________________________________________________________________________________
Bob Pusateri
Microsoft Certified Master: SQL Server 2008
Blog: The Outer Join[/url]
Twitter: @SQLBob
January 14, 2014 at 12:50 pm
Because this is not true log shipping. I have no control over the primary server - it belongs to the vendor and I can't touch it. Instead, they are sending...
_______________________________________________________________________________________________
Bob Pusateri
Microsoft Certified Master: SQL Server 2008
Blog: The Outer Join[/url]
Twitter: @SQLBob
January 14, 2014 at 10:06 am
Good point, Steve.
Actually I busted out Process Monitor yesterday to see how it was scanning the log files in the directory and found out that file names do matter -...
_______________________________________________________________________________________________
Bob Pusateri
Microsoft Certified Master: SQL Server 2008
Blog: The Outer Join[/url]
Twitter: @SQLBob
January 14, 2014 at 9:22 am
I'd say this behavior is pretty consistent - I have re-restored the full backup 4-5 times and have the same behavior each time.
_______________________________________________________________________________________________
Bob Pusateri
Microsoft Certified Master: SQL Server 2008
Blog: The Outer Join[/url]
Twitter: @SQLBob
January 13, 2014 at 1:24 pm
Good question. This is a new setup so no it has never worked before (because it has never been attempted). However I can successfully restore the log backups manually, so...
_______________________________________________________________________________________________
Bob Pusateri
Microsoft Certified Master: SQL Server 2008
Blog: The Outer Join[/url]
Twitter: @SQLBob
January 13, 2014 at 1:18 pm
Hi Jim,
A differential backup contains all the changes made since the last full backup.
In your case, if you are taking a full backup and then rebuilding the indexes afterwards,...
_______________________________________________________________________________________________
Bob Pusateri
Microsoft Certified Master: SQL Server 2008
Blog: The Outer Join[/url]
Twitter: @SQLBob
May 13, 2013 at 10:11 am
Hi Inder,
The short answer is no, you cannot natively restore a single table. Without a third-party tool your best bet is probably to restore the database somewhere else and copy...
_______________________________________________________________________________________________
Bob Pusateri
Microsoft Certified Master: SQL Server 2008
Blog: The Outer Join[/url]
Twitter: @SQLBob
February 15, 2013 at 8:02 am
Probably the easiest option (if possible) is for the offsite backups to be copied off the NAS you're already using, so you don't have to create extra backups.
If that's not...
_______________________________________________________________________________________________
Bob Pusateri
Microsoft Certified Master: SQL Server 2008
Blog: The Outer Join[/url]
Twitter: @SQLBob
February 10, 2013 at 9:30 am
I'd say the absolute worst-case for data loss would be 15 minutes, but that's assuming that the transaction log is totally destroyed and unable to be recovered, and your log...
_______________________________________________________________________________________________
Bob Pusateri
Microsoft Certified Master: SQL Server 2008
Blog: The Outer Join[/url]
Twitter: @SQLBob
November 19, 2012 at 10:17 am
To me, the advantage of Maintenence Plans is that they're easy - especially for people who need to get maintenance tasks done but don't know how to write T-SQL (think...
_______________________________________________________________________________________________
Bob Pusateri
Microsoft Certified Master: SQL Server 2008
Blog: The Outer Join[/url]
Twitter: @SQLBob
September 25, 2012 at 6:13 am
I'm not aware of any views or SPs that expose this information - I've only ever seen examples using the tables.
I of course can't guarantee anything, but given that...
_______________________________________________________________________________________________
Bob Pusateri
Microsoft Certified Master: SQL Server 2008
Blog: The Outer Join[/url]
Twitter: @SQLBob
September 5, 2012 at 12:51 pm
Probably the easiest way is to look at the physical_device_name column of the msdb.dbo.backupmediafamily system table. This table contains an entry for each backup, and with some joins to other...
_______________________________________________________________________________________________
Bob Pusateri
Microsoft Certified Master: SQL Server 2008
Blog: The Outer Join[/url]
Twitter: @SQLBob
September 5, 2012 at 8:27 am
Viewing 15 posts - 1 through 15 (of 19 total)