Viewing 15 posts - 7,486 through 7,500 (of 9,244 total)
Is this a clustered install by any chance??
October 25, 2010 at 2:16 am
ALZDBA (10/24/2010)
- Why don't you just directly 7zip your existing full backup file(s) ?
that's what i wondered!
October 24, 2010 at 9:29 am
YSLGuru (10/12/2010)
Change the Recover Model to SIMPLE and flush out the Log file so that it is as small as possible.
Generally, but this doesn't always happen!
7zip is free, use this...
October 24, 2010 at 8:56 am
dcohn99 (10/23/2010)
What size is the log set to be to determine when it is 70% full? Can you...
October 23, 2010 at 7:04 pm
Firstly SP_Attach_DB is deprecated in future versions of SQL Server the following statement should be used instead
CREATE DATABASE FOR ATTACH
The link you posted is fairly dated and really only applicable...
October 23, 2010 at 3:19 am
chetanr.jain (10/23/2010)
Well, i am surprised to see that.. Why the log is been at 100 GB. Why checkpoint has not been occurred.
When the database is set to truncate on checkpoint...
October 23, 2010 at 3:01 am
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
Viewing 15 posts - 7,486 through 7,500 (of 9,244 total)