Viewing 15 posts - 3,151 through 3,165 (of 9,253 total)
smtzac (7/23/2014)
-- Switch to your database
USE ngmetadata;
GO
-- Check VLF Count for current database
DBCC LogInfo;
-- Check individual File Sizes and space available for current database
SELECT name AS [File Name]...
July 24, 2014 at 4:14 am
vsamantha35 (7/23/2014)
On a cluster, we have 2 networks i.e private network and public network.
Private network is used for cluster communication(LooksAlive and IsAlive checks) and Public network is used for client...
July 24, 2014 at 4:04 am
don't ever delete the TUF file, this will require a re initialisation of the LS plan
July 24, 2014 at 4:02 am
Jeff Moden (7/21/2014)
Perry Whittle (7/21/2014)
Steve Jones - SSC Editor (7/21/2014)
GilaMonster (7/16/2014)
Steve Jones - SSC Editor (7/16/2014)
Yes. I believe you can use copy only, which avoids this
Full backups do not break...
July 23, 2014 at 4:12 pm
Steve Jones - SSC Editor (7/21/2014)
GilaMonster (7/16/2014)
Steve Jones - SSC Editor (7/16/2014)
Yes. I believe you can use copy only, which avoids this
Full backups do not break the log chain. Copy...
July 21, 2014 at 2:23 pm
cstrati (7/20/2014)
and is on a different domain
You never mentioned this before, complicates things even further. Is there a trust relationship between the 2 domains?
You really should be working...
July 21, 2014 at 12:24 am
Orphaned users on the mirror.
Check sids between the primary and mirror
July 18, 2014 at 7:50 am
You can attach\restore a sql server 2005 database to a sql server 2012 server without any problems
July 17, 2014 at 11:09 am
ensure you transfer any logins that may be required for the db
July 17, 2014 at 4:27 am
tcronin 95651 (7/16/2014)
July 17, 2014 at 4:24 am
Edward-445599 (7/16/2014)
Log shipping is set up and TRN file are being outputted to \\tlogs
If I now set up a maintenance plan to do nightly backups and 30 minute backup...
July 17, 2014 at 4:12 am
muthyala_51 (7/16/2014)
We have high safety with automatic failover setup in our Sql Server 2008 R2 environment, and automatic failover is functioning without any issues. All the applications are also working...
July 17, 2014 at 4:08 am
Edward-445599 (7/17/2014)
When log shipping is set up, are the log shipping backups then same as a standard backup and log backups?
Yes, a LogShipped database will have a transaction log backup...
July 17, 2014 at 3:52 am
smtzac (7/16/2014)
After do 'remove' mirroring there will be...
July 17, 2014 at 3:49 am
Whilst the link provided is good, you likely have a network issue here. Are the SQL server and file share witness machines on separate network portions?
Try implementing a file share...
July 17, 2014 at 3:38 am
Viewing 15 posts - 3,151 through 3,165 (of 9,253 total)