Viewing 15 posts - 4,246 through 4,260 (of 9,722 total)
It would help us to help you if you could post some DDL and sample data in the form of INSERT scripts. Then post an expected result and a copy...
July 5, 2012 at 10:44 am
Have tried loading your entire query into a variable first and doing EXEC(@MyVar)?
Can you run the create login statement by itself without the variable & dynamic SQL?
July 5, 2012 at 10:42 am
You could try logging this with a DDL trigger or coding your own version of an audit by using the undocumented deleted table.
Or you could simply set up some operational...
July 5, 2012 at 10:39 am
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
Viewing 15 posts - 4,246 through 4,260 (of 9,722 total)