Viewing 15 posts - 241 through 255 (of 372 total)
so restore in no recov, add my diff in no recov, then add manual logs in no recov, then start log shipping with secondary alreay initl in standby mode and...
September 26, 2013 at 2:56 pm
george sibbald (9/26/2013)
Do I restore in norecov, add diff with no recov and logs with no recov, then do standby for applying tran logs
Thats correct, restore the full backup and...
September 26, 2013 at 2:07 pm
not 2012, I wish, always on would be great, I was thinking SS but I am on standard, BOO!
the database is a sharepoint content, unable to do replication. How...
September 26, 2013 at 1:17 pm
The problem is the syntax at TargetInstance. I am looking how to fix it for you.
September 17, 2013 at 9:04 am
bubby (8/21/2013)
Error is as below,Progress: Execute DTS 2000 Package Task initiated - 0 percent complete
Error: System.Runtime.InteropService.COMException {0x80040427}
SQL Platform I have is SQL 2008 R2,
Help is appreciated,
Regards,
Bubby
Your package will not work...
September 13, 2013 at 1:38 pm
Um, NO! not good...
C:\ - OS only
E:\ - Apps - install of sql, various third party if any, ever
M:\ Mdf files - Data files
L:\ ldf files - only logs
T:\ tempdb...
September 13, 2013 at 1:33 pm
It sounds to me that the memory is set to default on the database engine and in turn SQL will take all the memory on the machine if not set...
September 13, 2013 at 1:27 pm
Rod,
you can one of two things here.
a) create the current users under security and once you restore they will sync up.
b) new site new names, no worries, restore the database,...
September 6, 2013 at 10:24 am
Open a call with MS, this happened to me and they had to log in and fix it and no I don't remember what they did, we ran so many...
September 6, 2013 at 8:11 am
Rod, did you understand what Mike is saying? Please PM me if you need more explaination. 🙂
September 6, 2013 at 8:07 am
TheSQLGuru (9/5/2013)
I always recommend full install too. Upgrade-install doesn't give me a warm-and-fuzzy at all.
DITTO! Upgrading is painful and I avoid it all costs, backup, backup, backup, uninstall, install!...
September 5, 2013 at 9:54 am
If it’s your dev. environment this is what I would do. Backup your stuff first all of it, Uninstall 08R2 completely, including the all folders. install 2012.
September 5, 2013 at 9:16 am
No. What procedures are you taking to move over your databases from 05 to 12? Backup and restore I hope!
September 5, 2013 at 9:12 am
http://technet.microsoft.com/en-us/library/hh245119.aspx
I found all my answers here. Hope this helps as well.
September 5, 2013 at 8:12 am
Viewing 15 posts - 241 through 255 (of 372 total)