Viewing 15 posts - 631 through 645 (of 757 total)
baabhu (12/15/2011)
December 21, 2011 at 3:18 am
pandisam66 (12/1/2011)
Hi,If you dont have full backup, you should wait 100% completion of Database full backup. Then only you can take Transactional log backup.
Thanks
Sam
Ok, got it
December 1, 2011 at 12:24 am
SpringTownDBA (12/1/2011)
December 1, 2011 at 12:23 am
pandisam66 (12/1/2011)
Hi,If you break the log chain, you cannot re-enable log shipping between primary and secondary databases.
If the full backup is running, log backup wont happen.
Thanks
Sam
I know that...
December 1, 2011 at 12:07 am
derekr 43208 (11/30/2011)
SpringTownDBA (11/30/2011)
Uh, why do you want to break the log chain?There aren't really any good reasons to do so.
I'm doing this on a test basis - I want...
December 1, 2011 at 12:06 am
SpringTownDBA (11/30/2011)
Uh, why do you want to break the log chain?There aren't really any good reasons to do so.
I'm doing this on a test basis - I want to know...
November 30, 2011 at 11:41 pm
Jinu43 (11/29/2011)
November 30, 2011 at 6:47 am
raotor (11/29/2011)
By the way, everything is running locally. i.e. all drives and my SQL Server/SSMS are...
November 29, 2011 at 5:48 am
raotor (11/29/2011)
I'm sure this question has probably been asked many times, but as I am new to SQL I wonder if someone good person out there could please indulge me...
November 29, 2011 at 5:31 am
Pouliot Philippe (11/25/2011)
use the same query with a exec sp_msforeachdb ' ... '
Try this link for some info
http://www.sqlservercentral.com/Forums/Topic1195196-392-4.aspx#bm1196262
November 29, 2011 at 3:04 am
Evil Kraig F (11/29/2011)
derekr 43208 (11/28/2011)
Something like this
start /wait <CD or...
November 29, 2011 at 12:38 am
This process is different in 2008 though.
November 28, 2011 at 11:22 pm
If the Master DB is corrupt, you will have to rebuild it - this is done with the installation media.
Something like this
start /wait <CD or DVD Drive>\setup.exe /qn
INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine
REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
Then...
November 28, 2011 at 11:21 pm
viiki.seth (11/24/2011)
I did SP4 installation on services stopped. it went fine without any issue.
Ok
I have reporting services as well, does this make a difference?
Should the SP be applied to Reporting...
November 24, 2011 at 11:03 pm
Viewing 15 posts - 631 through 645 (of 757 total)