Viewing 15 posts - 7,501 through 7,515 (of 9,253 total)
richsilv (10/22/2010)
In your opinion, what is the advantage of using it over what I did?
Using detach\attach to move database files is not the MS recommended way to achieve this. It's...
October 22, 2010 at 4:16 pm
Learn_something_new_everyday (10/22/2010)
We don't write the code we just have to support it.
😉 tell me about it!
October 22, 2010 at 2:35 pm
why did you detach and re attach, why didn't you just use
ALTER DATABASE MODIFY FILE
October 22, 2010 at 1:38 pm
Craig Farrell (10/22/2010)
Logs, even in simple mode, are incredibly important. They just take up less room.
this is not necessarily true, it is possible to have huge log files even...
October 22, 2010 at 1:32 pm
it would default to the Computers OU but could be moved almost anywhere. Go into AD users and computers console and in the left pane right click the domain and...
October 22, 2010 at 11:22 am
OK, I'm slightly confused here!!
Duran (10/22/2010)
October 22, 2010 at 9:43 am
dcohn99 (10/21/2010)
October 22, 2010 at 9:26 am
icampbell (10/22/2010)
synchronise
Elaborate a little more for us could you please?
Exactly what is it you intend to do?
October 22, 2010 at 9:17 am
SkyBox (10/22/2010)
Yeah - I noticed that the maint. plan cleanup uses the XP_Delete_File proc.Thanks Perry
😉
October 22, 2010 at 9:12 am
sqlbee19 (10/21/2010)
Thanks.Do I need to set Max memory and min memory if I enable lock pages in memory setting ???
The KB link posted above by Gianluca Sartori quotes...
October 21, 2010 at 4:22 pm
Vikash
presumably when you designed the package you ran with a connection configured to a test database. Now you have deployed the package did you change the connection to connect to...
October 21, 2010 at 4:03 pm
use the extended stored procedure XP_Delete_File to remove old backup files, it deletes based on the file date.
October 21, 2010 at 3:45 pm
correct, you may use a SQLExpress instance for the witness server!
October 21, 2010 at 11:03 am
Just a word of warning about Diff backups. They incorporate all the changes since the last Full, they append each time and will get bigger and bigger until the next...
October 21, 2010 at 8:12 am
for the "FailoverPartner=" clause to work you must be using ADO.NET or SQL Native client for your database connection!
October 21, 2010 at 7:56 am
Viewing 15 posts - 7,501 through 7,515 (of 9,253 total)