Viewing 15 posts - 4,231 through 4,245 (of 9,707 total)
SQLRNNR (7/5/2012)
Thanks Brandie. I even like that you posted the script using dbcc timewarp. Notice the publish date is July 24, 2012.:-D
Shhhhh. You're not supposed to tell anyone....
July 5, 2012 at 10:17 am
That tells me Log Shipping isn't set up (or isn't set up properly) on your secondary server.
You'll need to start over from scratch.
July 5, 2012 at 9:10 am
thomasrichardson2000 (7/5/2012)
primary_idprimary_databasebackup_directorybackup_sharebackup_retention_periodbackup_compressionbackup_job_idmonitor_servermonitor_server_security_modebackup_thresholdthreshold_alertthreshold_alert_enabledlast_backup_filelast_backup_datelast_backup_date_utchistory_retention_period
C2BEA283-0F09-49C6-9B2A-1CEE4C626182mydatabase\\rentway1\BACKUP_RENTWAY\\rentway1\BACKUP_RENTWAY4320235497C9B-6E5D-4A1F-A0C2-3FB166FF7FD5NULLNULL60144201\\rentway1\BACKUP_RENTWAY\mydatabase_20120705133000.trn2012-07-05 14:30:05.3472012-07-05 13:30:05.3435760
cheers
Where's the second one? For the Secondary Database?
July 5, 2012 at 8:38 am
Michael Valentine Jones (7/5/2012)
Then you can...
July 5, 2012 at 7:00 am
Oh good grief. Nevermind.
We're getting a new type of file that hasn't been accounted for. DOH.
July 5, 2012 at 6:50 am
rodjkidd (7/5/2012)
Brandie Tarvin (7/5/2012)
http://lasrsff.blogspot.com/2012/07/legend-of-beemen-by-brandie-tarvin.html
Excuse me while I...
July 5, 2012 at 5:24 am
Can you paste the actual command into the thread? Feel free to change the sensitive information. We just need to see the entire command.
July 5, 2012 at 5:13 am
ChrisM@Work (7/5/2012)
Brandie Tarvin (7/5/2012)
http://lasrsff.blogspot.com/2012/07/legend-of-beemen-by-brandie-tarvin.html
Excuse me while I...
July 5, 2012 at 4:58 am
Starting at the beginning, do you mean Last Day of:
1) The Fiscal Year (the business's accounting year)
2) The Calendar Year
3) The Business Year (slightly different from Fiscal)
4) The PayDay Year...
July 5, 2012 at 4:48 am
ssa2010 (7/5/2012)
Also mention the difference between SQL 2005 Express Edition and SQL 2008 Express Edition like their DB size limitation...
July 5, 2012 at 4:45 am
Bipan,
Could you rephrase your question? I didn't quite understand it.
July 5, 2012 at 4:43 am
When you initially set up log shipping, did you take a full backup of the primary db and restore it to the secondary server before kicking in the shipping?
Are there...
July 5, 2012 at 4:43 am
So I have a non-SQL related WHOOT of my own. I got a 5 star review for my short story, Legend of the Beemen.
http://lasrsff.blogspot.com/2012/07/legend-of-beemen-by-brandie-tarvin.html
Excuse me while I bounce around like...
July 5, 2012 at 4:22 am
GilaMonster (7/3/2012)
For anyone not on/not paying attention to twitter.....It seems to be official.... I'm a Microsoft Certified Master for SQL Server 2008.
https://twitter.com/SQLintheWild/statuses/220252281847808001
You go, girl!
Congratulations.
July 5, 2012 at 4:17 am
crookj (7/3/2012)
rhythmk (7/2/2012)
Revenant (7/2/2012)
Brandie Tarvin (7/2/2012)
RumbaRoomba
Brazil
brazier
bazaar
July 3, 2012 at 10:17 am
Viewing 15 posts - 4,231 through 4,245 (of 9,707 total)