Viewing 15 posts - 3,151 through 3,165 (of 9,244 total)
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2014 at 12:24 am
Orphaned users on the mirror.
Check sids between the primary and mirror
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2014 at 11:09 am
ensure you transfer any logins that may be required for the db
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2014 at 4:27 am
tcronin 95651 (7/16/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2014 at 3:52 am
smtzac (7/16/2014)
After do 'remove' mirroring there will be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2014 at 3:38 am
Beatrix Kiddo (7/16/2014)
Oh, also, would not specifying a catalog make the whole process any slower?Thanks again.
If anything should be faster as it won't have to enumerate all the other databases...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2014 at 8:40 am
Beatrix Kiddo (7/16/2014)
Thanks. So does that explain why the activity I'm seeing is in master?
If the users default database is master then yes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2014 at 8:39 am
SQLAddict01 (7/16/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2014 at 8:38 am
a linked server can (and arguably should) use a default catalog. If one is not specified the linked server will allow access to all databases the user has access to....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2014 at 6:03 am
nvalia (7/15/2014)
Current SQL Server 2005 SP2 is on Windows 2003 Server (Not to be used post Migrating Databases)
SQL Server 2012 is going to be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2014 at 3:31 pm
Viewing 15 posts - 3,151 through 3,165 (of 9,244 total)