Viewing 15 posts - 3,166 through 3,180 (of 9,241 total)
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
To move master you'll also need to move the resource database too. Move master using the following
edit the SQL server service and change the paths for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2014 at 3:09 am
go onto the remote server and find the backups share. You need to check and set Share permissions then move to the folders security tab and set NTS ACLs too.
The...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2014 at 2:50 am
gwellbrock (7/10/2014)
The load of the databases require 3 active servers.
Do you mean you distribute the databases between 3 separate SQL server instances?
gwellbrock (7/10/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2014 at 2:48 am
Viewing 15 posts - 3,166 through 3,180 (of 9,241 total)