Viewing 15 posts - 4,321 through 4,335 (of 9,244 total)
SQLDBA360 (2/11/2013)
Nice artical, I must admit i'm still a fan of detatching the databases to move files
No longer necessary to detach the database. The ALTER DATABASE ... MODIFY FILE command...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2013 at 2:38 am
Willem Gossink (2/11/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2013 at 2:32 am
Pradeep Hebballi (2/11/2013)
Hi Perry, the article was really helpful. Thanks!
Thank you, i'm glad you found it useful\helpful
Pradeep Hebballi (2/11/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2013 at 1:15 am
Richard Fryar (2/8/2013)
This script checks all databases in one go, and avoids use of a cursor.
Have you seen the code for sp_MSForeachdb????
SQLCrazyCertified (2/8/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2013 at 1:02 pm
SQLCrazyCertified (2/8/2013)
Hi Perry,So, basically what it is doing is, it is creating the login using the SID of the user? and mapping it?..
No, it's not!
Its finding a database user and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2013 at 9:11 am
sotn (2/8/2013)
if no activity is performed for 12 hours (overnight) then does not seem make sense to perform 24 tlog backups with no real activity....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2013 at 4:51 am
GilaMonster (2/6/2013)
even then a diff backup's usually easier.
Providing a full backup hasn't occurred since the LS plan broke otherwise the Differential_Base_LSN is incremented and the Diff will no longer be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2013 at 9:56 am
Knut_knut (2/7/2013)
ESX version (know its 4 or 5 not sure though)
Important to know, there's big differences and improvements between 4.0, 4.1 and 5.1 😉
Knut_knut (2/7/2013)
How the disks are mapped
You...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2013 at 9:32 am
george sibbald (2/7/2013)
You would be best pausing log jobs, taking a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2013 at 9:06 am
1 and 3 are essentially the same arent they?
Knut_knut (2/7/2013)
This method...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2013 at 9:05 am
In a Windows domain, domain user accounts are preferred. If you expect DC issues then the real issue is with your physical AD design\topology 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2013 at 5:21 am
This from Microsoft themselves 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2013 at 5:19 am
what are you trying to extract?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2013 at 4:50 am
The only time the auto registering of SPNs will work when running as a domain account is if the account is an administrator or it has been granted readServicePrincipalname and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2013 at 4:44 am
Have you taken any full backups since LS broke, if not you may restart LS with a differential backup
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 6, 2013 at 4:01 pm
Viewing 15 posts - 4,321 through 4,335 (of 9,244 total)