Viewing 15 posts - 3,151 through 3,165 (of 9,241 total)
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
nvalia (7/15/2014)
My concern with the direct route is, upgrading a Service Pack in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2014 at 2:32 pm
Noam Graizer (7/15/2014)
finally we found the correct solution:after you remove file from the DB, you have to backup log
this reset the sys.database_files table
now we successed to add files ...
For...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2014 at 1:43 pm
Rudyx - the Doctor (7/15/2014)
I would just apply 2005 SP4 as a part of the process then go to 2012.This way you avoid any 'potential' licensing issues.
In between this is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2014 at 1:41 pm
Viewing 15 posts - 3,151 through 3,165 (of 9,241 total)