Viewing 15 posts - 5,371 through 5,385 (of 9,253 total)
thanks for letting us know. Something i've done before is to extract the system db backups to a running instance as user databases, detach them and rename the files then...
July 10, 2012 at 5:03 am
jitendra.padhiyar (7/9/2012)
According to my knowledge, they will not be deleted on secondry server, it will be deleted on Primary server.
Au contrair mon pere 😉
sufiyan.sarguroh (7/10/2012)
July 10, 2012 at 4:54 am
adb2303 (7/10/2012)
Can kerberos be used against a Client Access Point in a SQL Server cluster? I registered SPN's for the SQL Server service account using setspn, but the authentication...
July 10, 2012 at 4:46 am
You may not need to rebuild, does the instance start in single user mode?
If so just proceed with the restores if the backups are recent.
If the instance does not...
July 9, 2012 at 1:10 am
why not implement a log shipping configuration, this would be very easy to setup and maintain
July 6, 2012 at 8:37 am
NT Password reset is free, use that instead 😉
July 6, 2012 at 8:35 am
you may setup a mirror session using an IP address, this is detailed here.
This may be useful too.
You'll need to set up a 2nd clustered IP for the 2nd nic.
July 6, 2012 at 8:27 am
ksrikanth77 (7/5/2012)
Let me explain me the scenario
I have created SQL Server...
July 5, 2012 at 3:49 pm
kevinsql7 (7/5/2012)
For SQL Server 2008 R2 SP 1, I have found the following exe on http://www.microsoft.com/en-us/download/details.aspx?id=26727:SQLServer2008R2SP1-KB2528583-x64-ENU.exe
Use this file
July 5, 2012 at 3:46 pm
You're generally stuck with 2 options mentioned.
Option1
Detach or offline database (generally almost instantaneous)
Copy files (takes time)
Reattach files (generally almost instantaneous)
Option2
Take compressed backup (can take time)
Copy compressed back (usually quick)
Restore backup...
July 5, 2012 at 2:01 pm
AAKR (7/5/2012)
Example:
I am having a XXX database in ABC server, I want to move this database...
July 5, 2012 at 10:26 am
thomasrichardson2000 (7/5/2012)
sorry there is no second one ,it returns no rows
Check to make sure you supplied the correct database name.
If still no rows then as Brandie says, the LS secondary...
July 5, 2012 at 9:44 am
marks_262 (7/5/2012)
I am looking for some scripts or a tool (preferably...
July 5, 2012 at 6:07 am
Please execute the following and return the results
against primary
exec sp_help_log_shipping_primary_database @database = 'yourdb'
against secondary
exec sp_help_log_shipping_secondary_database @secondary_database = 'yourdb'
July 5, 2012 at 6:05 am
Viewing 15 posts - 5,371 through 5,385 (of 9,253 total)