Viewing 15 posts - 601 through 615 (of 4,745 total)
if you do that you will lose point in time recovery and may as well put the database in simple mode.
(truncate_only is deprecated by the way)
do you need point in...
June 11, 2013 at 7:08 am
for tempdb (only) initial size shows the file size at create time, it does not reflect autogrowths. (a manual growth via alter database would be reflected as this would change...
June 11, 2013 at 7:03 am
you need to be truncating the log, that is removing the committed data. A shrink will not do this, and will likely have no effect if there is active data...
June 11, 2013 at 6:59 am
don't completely empty them as they are used by the gui to create restore histories if you use them to do restores. they can be useful in a disaster situation...
June 11, 2013 at 6:45 am
you can connect using the virtual name, so you don't need to know which node is active. If you do know which node is active you can connect by that...
June 11, 2013 at 4:32 am
plus the shrink will cause heavy fragmentation so there will be more for the rebuild\reorg to do.
June 11, 2013 at 3:48 am
The SQLAgent files are the errorlogs for SQLAgent. Do not delete the .OUT file as that is the current one. there should be no more than 6 cycles of these...
June 10, 2013 at 10:23 am
A free tool such as 7-zip may be able to compress a file that size, not sure.
June 6, 2013 at 3:04 am
Unless you can do SAN replication between the data centres and then attach the database files at cutover time you are looking at copying over the full backup and restoring,...
June 5, 2013 at 11:16 am
the error message implies the service has not been started in single user mode. Have you got the right instance?
post exactly what you have done.
see http://msdn.microsoft.com/en-us/library/ms180965(v=sql.100).aspx
May 28, 2013 at 6:56 am
check any maintenance plans as well if you have them.
May 27, 2013 at 10:41 am
I too was hoping this was a humour question worth lots of easy points..............
especially as its a bank holiday here.
May 27, 2013 at 4:39 am
the file format is the same for 32bit and 64bit so you can copy from one to the other.
Is the new machine name going to be the same? I always...
May 21, 2013 at 1:32 pm
[quote-0Msg 3201, Level 16, State 2, Line 2
Cannot open backup device 'C:\Test\CHxxx_backup_2013_05_20_190005_1282827.bak'. Operating system error 3(The system cannot find the path specified.).
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE...
May 21, 2013 at 11:24 am
EdVassie (5/20/2013)
There are no data integrity or performance reasons for...
May 20, 2013 at 6:31 am
Viewing 15 posts - 601 through 615 (of 4,745 total)