Viewing 15 posts - 3,166 through 3,180 (of 9,244 total)
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
Chowdary's (7/11/2014)
T.log can not be restored on the secondary Database which is due to that transaction log sequence is broken.in that time what we will check & do .
Please...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2014 at 8:14 am
very easy to do on a maintenance window and also checks that you still know how to perform this action
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2014 at 8:06 am
It's one alter command per file when modfying, never been a bother for me
you're only typing multiple alter statements, not as if it's a hardship 😉
ALTER DATABASE somedb MODIFY FILE
What...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2014 at 8:04 am
nvalia (7/14/2014)
Current SQL Server Details-
Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2014 at 7:55 am
khott (8/8/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2014 at 7:48 am
since a restart of the instance is necessary i would recommend you just remove the file at your next maintenance window. Start the instance single user and remove it.
Note this...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2014 at 7:10 am
Noam Graizer (7/15/2014)
I can re-do this "alter database ...remove file" and this leaves the rows in the sys.database_files !!!
OOO !!!
I don't know what...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2014 at 5:17 am
inevercheckthis2002 (7/11/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2014 at 4:49 am
cstrati (7/14/2014)
The SQL Service account is logged on as "Network Service" instead of a domain network account.Am I still able to give it permissions to the backup server somehow?
Did you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2014 at 1:07 am
You can edit the parameters via the registry, take a backup of the keys before you change them
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2014 at 11:31 am
check the cluster events and the windows application logs first
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2014 at 3:16 am
TryingToLearn (7/10/2014)
Giving the Service account 'domain admin' privileges for a brief time allowed the SPN error to correct itself or register properly.Thank you
Exactly what you shouldnt do.
Either grant the new...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2014 at 3:11 am
Viewing 15 posts - 3,166 through 3,180 (of 9,244 total)