Viewing 15 posts - 3,511 through 3,525 (of 9,241 total)
robin.pryor (2/26/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2014 at 9:27 am
SQL-DBA-01 (2/25/2014)
Hi,How to find when (date/time) a database was last removed from AlwaysOn Listener?
Is there any query (DMV) to find the details easily?
AlwaysOn databases are bound to an AlwaysOn group,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2014 at 2:24 am
quackhandle1975 (2/25/2014)
then restore a full bk from source instance and run all the checks at that point
That is another way. Typically time it so the database is migrated fairly soon...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 25, 2014 at 11:06 am
grantbanjo (2/24/2014)
I first ran a search for on the Internet and then on SQL Server Central for this situation, but was unable to find a close match.
I have SQL Server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 25, 2014 at 2:51 am
When you attach\restore the 2005 database to 2008 the database will go through an internal SQL Server upgrade, this does complete a fair amount of logical checks. Get the database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 25, 2014 at 2:45 am
check the cluster events for any errors. Have you perfomed a cluster validation after adding the new node to the Windows cluster but before attempting to run the SQL Server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 25, 2014 at 2:42 am
Have you checked the restore job step history closely. The step may indicate restore issues but still marks as successful.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 25, 2014 at 2:39 am
what is the recovery model for this database
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 25, 2014 at 2:36 am
Adam Bean (2/24/2014)
When opening .sql files, I get a connect to database engine prompt every single time. Never had this problem before and not sure when it started or...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 25, 2014 at 2:27 am
why would it affect performance, it basically tells sql server not to use the new style of identity maintenance and act like a sql 2008 instance in that respect
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 24, 2014 at 7:33 am
nikhil.desai1 (2/24/2014)
Hi,What will be the best option for DBA to physically locate Witness server at PROD site or at DR site in Database mirroring ?
Thanks and Regards,
Nikhil P Desai
You do...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 24, 2014 at 5:44 am
It forces identities in sql server to behave as it did in previous versions. The trace flag is added to the service startup list to persist it on service restarts.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 23, 2014 at 11:51 pm
Are you receiving this after your domain migration?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 23, 2014 at 4:05 pm
It sounds like the datafiles still exist on disk. Rather than creating a new database, try Attaching an existing database and browse to the disk files.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 23, 2014 at 4:02 pm
I have worked with a few applications in the past that all required elevated privilege. This is a typical candidate for ring fencing to a separate instance.
If the application is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 23, 2014 at 3:58 pm
Viewing 15 posts - 3,511 through 3,525 (of 9,241 total)